I had this problem before and I believe it came down to the fact that the user that the php process runs as does not have access to connect to your other machine. IIS sets up a user (I can't remember its name off hand, I think it is something like IWAM_USER) to access the other machine, but it only has user-level privileges, which is not enough to access your remote server. I assume you mean you're using MS query on the win2000 machine. This is a pretty good indication of the fact that it's down to the user that IIS connects as. I ended up not connecting to a remote database - I created a local access database that synchronises with the remote one as a batch event (using the Scheduled Task Manager). This approach was a bit more work at first, but it meant that I kept better separation between my main database and what I wanted to allow onto the net. FYI: There is an acknowledged bug in IIS that when you uninstall IIS the permissions related to the users it creates do not get properly deleted. This means that every five minutes the permissions manager throws two errors that appear in the application event log. Once that gets full (about every two days) the machine in question grinds to a halt. Therefore if you decide to move to Apache then leave IIS on the machine but disable it in Control Panel. I hope this helps, Martin Kemp > -----Original Message----- > From: Schulz, Evan [mailto:[EMAIL PROTECTED]] > Sent: 02 August 2001 10:47 > To: '[EMAIL PROTECTED]' > Subject: ODBC + Win 2000 problem > > > 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. > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
