ODBC + Win 2000 problem

From: 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.

« previous php.windows (#8636) next »