ODBC Error?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
dstefani
Forum Contributor
Posts: 140
Joined: Sat Jan 11, 2003 9:34 am
Location: Meridian Idaho, USA

ODBC Error?

Post 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
prasaderandi
Forum Newbie
Posts: 10
Joined: Fri Jul 01, 2005 1:09 pm

Post by prasaderandi »

reinstalle ODBC driver
User avatar
dstefani
Forum Contributor
Posts: 140
Joined: Sat Jan 11, 2003 9:34 am
Location: Meridian Idaho, USA

Post 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
Post Reply