Hi,
I am developing a web site using the following :
- 2 x servers
- IIS5 server running on Windows 2000 Small Business Server - NetBIOS name WWWSERVER, running as PDC
- Windows 2000 Server – NetBIOS name SERVER2, running as BDC (this box holds DBF data files that I need to read)
- PHP 4.3.2 installed on WWWSERVER
- ODBC Microsoft Visual FoxPro driver (Free Table Directory) for DBF files setup on WWWSERVER
- System DSN called “TESTDSN” using the above driver created on WWWSERVER
- I have pages on WWWSERVER that connect to the TESTDSN ODBC connection.
- The IIS server is using the IUSR_WWWSERVER account for anonymous access. Both servers have this account and synchronization between PDC and BDC appears to be working OK
Now to the problem, if the ODBC connection on the web server points to \WWWSERVER\WEBDATA everything is fine
If the ODBC connection on the web server points to \SERVER2\WEBDATA I get the following error returned from the ODBC driver.
“Warning: SQL error: [Microsoft][ODBC Visual FoxPro Driver]File 'xxxxxxxx.dbf' does not exist “
This happens regardless of the table trying to be accessed.
Both the \WWWSERVER\WEBDATA and \SERVER2\WEBDATA directories are identical and have the same share permissions and directory security settings.
If I switch IIS to use integrated password authentication and logon to the website using a domain user, all works OK using the desired \SERVER2\WEBDATA path, I assume because that user has a certain privilege that IUSR_WWWSERVER does not ?? I need to use anonymous access in this case.
If I switch the anonymous user account on IIS to be “Administrator”, I still get the error when trying to access the tables via ODBC, so I’m not sure it is actually a security problem.
I have verified that PHP.EXE is being run as the IUSR_WWWSERVER account by returning the user through PHP.
I have tried creating the TESTDSN ODBC connection on SERVER2 but didn’t make any difference.
Questions:
- Has anyone struck this problem before ? I can reproduce on two different networks.
- Is the issue possibly with PHP privileges ?
- Any ideas as to how I can call the ODBC connection on SERVER2 directly from WWWSERVER ?
- Any other ideas appreciated.
- This is very urgent/important, any help would be greatly appreciated to get me out of a gigantic hole !!! Your help will not go unrewarded !!
Many thanks.
Andrew
