Unable to access Access DB via ODBC under IIS under WIN2K
| From: | Bill Seeley | Date: | Tue, 05 Feb 2002 13:22:12 +0000 |
| Subject: | Unable to access Access DB via ODBC under IIS under WIN2K | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-11847@lists.php.net to get a copy of this message | ||
When attempting to query an Access 2K DB with the odbc_connect function, I
get the messsage:
Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified, SQL state IM002 in SQLConnect in
e:\vnpweb\html\getcontact.php on line 14 IM002
I have tried both the CGI (installer version) and ISAPI versions of PHP
4.1.1 (manual install) and get the same messages. I am able to access this
same data source name with Crystal Reports and was previously able to access
it with a PHP script under an Apache server (php4apache.dll version) on the
same machine. I've enabled both ODBC and PHP logging, but PHP logging
doesn't give me any more than the above messages. Curiously the ODBC log is
empty, even though the above messages would indicate that the MS ODBC driver
returned a legitimate error code.
Has anyone seen anything like this and can you offer any suggestions?
Thanks, Bill Seeley