Forums

This topic is locked

Why can't I establish a conn to the data source??

Posted 04 Oct 2001 17:07:57
1
has voted
04 Oct 2001 17:07:57 spencer mr. posted:
My configuration:

All my site files are on a remote server including a simple db. When I try to specify the database connection through my local computer, I get these errors:

I have a simple access db on a remote server and when I try to specify the database connection through my local pcI get:

My problem:

Within 'Connection' dialog box:

I get this error when I try to test the connection to a data source on a remote server, when I've specified within the DSN dialog box "Using DSN on App Server".

Operation was canceled.

Operation was canceled.

-------------------------------

And when I specify 'Using Local DSN', it returns with this error:

[Microsoft][ODBC Microsot Access Driver]General error Unable to open registry key
'SOFTWARE\ODBC\ODBC.INI\customer_db.mdb'.

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

Replies

Replied 18 Oct 2001 15:08:47
18 Oct 2001 15:08:47 simon bloodworth replied:
Hi

What is the Database you are trying to connect to Access or MySQL?

S Bloodworth

Reply to this topic