Connecting to remote VFP database using ASP

We are having a difficult time connecting to a Visual Foxpro database located
on a remote server using ASP.

It is a security issue because the web application can connect if the
database is located locally on the web server. When we point to the remote
database and run the code, the application cannot find the location.

We tried everything in the Microsoft KB article located at:
http://support.microsoft.com/kb/175801/en-us

but nothing seems to help. Our connection is through an ODBC System DSN that
uses a UNC path to the remote database.

Any advise or help would be appreciated.

Christof
Mon May 29 00:37:48 CDT 2006

Hi itmanager,

> It is a security issue because the web application can connect if the
> database is located locally on the web server. When we point to the remote
> database and run the code, the application cannot find the location.

Does the user which you use as the identity for the ASP page have the
network logon privilege on the other server? That is, the ASP application
must either use a domain account, or you must have an account on the file
server with the same name and password as the ASP account on the web server.
To verify this, right-click the VFP icon while holding down the SHIFT key.
Pick "Run As...". Log on with the same user name and password as the ASP
application. Try accessing the remote location.

If that's not the cause, you might want to use FILEMON from
http://www.sysinternals.com to find out which file is causing the error.