ODBC thru network?

blazin

Im experiementing with ODBC and Foxpro with PHP. I am able to open and read tables that reside on the same server as PHP/webserver, but when trying to look at other files that reside on the network, I get a message like this:

Warning: SQL error: [Microsoft][ODBC Visual FoxPro Driver]File 'stock.dbf' does not exist., SQL state S0002 in SQLExecDirect in C:\Inetpub\wwwroot\shop\odbc.php on line 4

The DSN is set up correctly pointing to the correct network path, and the file is there. If I move this file to the local drive, it works. Any ideas?

Vex

What webserver are you running and on what OS platform?

I'm guessing it's windows? What user account is the webserver running under? Does that user account have network access? If the webserver is running under 'Local System' then it won't have network access....

EDIT: C:\Inetpub - Right, windows, running IIS.... Not sure about IIS but check the user account.

blazin

Thanks for the quick reply!

I knew it had to be something security related. I'm working on NT 4.0 IIS 4.0 so I created a user name on the domain and specified IIS to use that as the anonymous account. Works great, but could there be any security risks in this?

Thanks

Vex

TBH, I don't know much about NT security, but yes there is a risk...

If your webserver is compromised then the hacker will now have easy access to your internal network, I'd guess....