Jerry,
Have you tried using impersonation? It sounds like you re having permission problems. Try impersonating an admin user to see if that makes a difference. Then you will know why the error was occuring. See Message #
682735 to see how to setup impersonation.
>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
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi