I am using ASP.Net to access VFP tables over a shared network drive. But when I perform the query I keep getting a "Invalid path or file name." in my Asp.Net page.

I am using the correct UNC path. One way to tell this is that I can do a DIR from a command prompt using the UNC path.

Also, in my machine.config, I set the user name and password to an admin account just so there is not a permission issue.

My connection string looks like this:
Provider=VFPOLEDB.1;Data Source=\\\\MyDomain\\myshare\\mydir\\mydir\\

Also, I am on a web farm, but I changed the machineKey to the same values on all the servers in the farm. So my ViewState should be set on all web servers.

Also, I copied the dbf to a local drive on all my web servers in the farm and changed the connection string to:
Provider=VFPOLEDB.1;Data Source=C:\\Data\\
This Works great, it just won't work over the share drive.

What else can I do to fix this?


Thanks,

Jerry