ODBC + Win 2000 problem
| From: | Schulz, Evan | Date: | Thu, 02 Aug 2001 21:46:47 +0000 |
| Subject: | ODBC + Win 2000 problem | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-8636@lists.php.net to get a copy of this message | ||
I have a Windows 98 machine running PWS and PHP 4.4pl1. I have a script
that accesses an MS Access 97 database on a Novell 5.0 file server through
ODBC. I just copied this same script to a Windows 2000 server running IIS
and PHP 4.06 CGI and I get the following error when it runs:
"Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] '(unknown)'
is not a valid path. Make sure that the path name is spelled correctly and
that you are connected to the server on which the file resides., SQL state
S1009 in SQLConnect in C:\path\index.php on line 175"
(Line 175 is the odbc_connect - I am not going to attach the actual code
because the code isn't the problem - it works on my other machine)
I tried going to PHP 4.04pl1 CGI, but same error. I tried installing Office
97's ODBC drivers...no change. I installed a couple of ODBC updates from
Microsoft - didn't help. When I copy the database locally and point the
ODBC data source there, it works! It makes it look like either the ODBC
Access driver is screwed up or there is a problem connecting to a database
with Novell. If I use MS Query and use the same ODBC data source, though,
everything connects just fine.
I have searched the Microsoft, Novell, and PHP sites pretty extensively and
didn't find a thing. The PHP mail archive had one person with the same
error with NT 4, but there was only one reply and it was "Your ODBC driver
to access Access may be the problem". This is a brand new install of 2000,
though, so I would think others would have gotten this if it was the driver.
Any (and I really do mean any) help would be greatly appreciated.