Page 1 of 1

ODBC Error?

Posted: Fri Jul 01, 2005 12:43 pm
by dstefani
Here is my connection code:

Code: Select all

$odbc = odbc_connect ('...', '...', '...') or die('Could Not Connect to ODBC Database!');
And here is the error it generates:
Warning: odbc_connect() [function.odbc-connect]: SQL error: , SQL state 00000 in SQLConnect in C:\Documents and Settings\...\web\wc_cat1.php on line 2
Could Not Connect to ODBC Database!
This is running on WinXP/IIS/PHP5, passwords, etc are not shown.
I don't usually deal with MSAccess DB, but I need to deal with old data
before I can export it. ARRRGGG!

The ODBC error docs say that 00000 is a success code!?!?!?

Have you delt with this before?

Thanks,

- dstefani

Posted: Fri Jul 01, 2005 1:53 pm
by prasaderandi
reinstalle ODBC driver

Posted: Fri Jul 01, 2005 2:57 pm
by dstefani
> reinstalle ODBC driver

Well,.. let's just say that wasn't it.

First, I had a username and password defined in the DSN and yet the DB was not password protected. i deleted those from the system DSN config and everything worked.

- Thanks