ODBC Connection in W2K
| From: | Gonzalo Vera | Date: | Thu, 24 Aug 2000 22:03:48 +0000 |
| Subject: | ODBC Connection in W2K | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-2120@lists.php.net to get a copy of this message | ||
I simply can't connect to Access via ODBC. I keep getting the
following error:
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified
ODBC seems to be correctly configured, my DSN is correct, user name
and pwd are untouched (Admin/no password), and I have used it on
machines with Win95/98 without any problems, but nothing going on
Win2K.
MS Knowledge base says:
"The ODBC driver manager could not find the ODBC data source. Make
sure the data source name was given correctly. Also make sure the data
source name was defined using the same Windows NT account the
application is running under, or it is an ODBC 2.5 system data source.
If the application is running as a Windows NT service, the data source
must be a system data source."
I can only guess at my ODBC version being wrong, how can I know that?
Any other ideas? I'm using PHP3.0.14 and Apache 1.3.12.
Thanks a lot.
Gonzalo.