Glad that worked.
>OK, the UNC path worked. Thank you very much.
>
>Jerry
>
>
>
>>Hi Jerry,
>>
>>You need to use a UNC path instead of a mapped path to the data. Also, if you are still having troubles after you make that change then it could be a rights issue since you are ruhning under the ASPNET account. See thread #
742132 for a situation similar to yours about how to change the rights if needed.
>>
>>>Using .NET 2003, I am creating a Webform that access a VFP free table.
>>>
>>>If my connection string points to a table on my hard drive, I can successfully query and display the data in my web form.
>>>
>>>However, if I change the connection string to point to a copy of the same table on our LAN, I get the following error when I run my Webform.
>>>
>>>Server Error in '/mydir' Application.
>>>--------------------------------------
>>>Invalid path or file name.
>>>blah, blah, blah
>>>
>>>
>>>Here's the code behind my Webform's button:
>>>
>>>///My command button click event.
>>>
>>>//Points to the network table.
>>>string lc_ConnectionString = "Provider=VFPOLEDB.1;Data " +
>>> "Source=f:\\data\\;Mode=ReadWrite|Share Deny None";
>>>//Points to the copy on my hard drive. This does work.
>>>//string lc_ConnectionString = "Provider=VFPOLEDB.1;Data " +
>>> "Source=c:\\apps\\;Mode=ReadWrite|Share Deny None";
>>>
>>>string SelectCmd = "SELECT employee.em_key, employee.em_userid, " +
>>> "employee.em_fulname, employee.em_email " +
>>> "FROM employee ";
>>>
>>>DataSet ds = new DataSet();
>>>
>>>OleDbDataAdapter DataAdapter = new OleDbDataAdapter(SelectCmd, lc_ConnectionString);
>>>
>>>DataAdapter.Fill(ds);
>>>
>>>grd_employee.DataSource = ds;
>>>grd_employee.DataBind();
>>>
>>>
>>>My dev PC is a WinXP Pro. I have Admin rights to our LAN.
>>>
>>>What can I do to allow my Webform to access a table on our LAN?
>>>
>>>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