Hi,
Drive mappings as user specific. Your ASP user probably doesn't have the mapping. Try using UNC
HTH,
Viv
>I have a Web Service that can query the data from the production server or from a test server, when we test before uploading a new version of the application. When on the production server, the data is local, so the code in the OleDbDataAdapter may look like this:
>
>
> Dim loDT As New OleDbDataAdapter(tcSQL, _
> "Provider=VFPOLEDB.1;Data Source=d:\www\foxpro;Password='';Collating Sequence=MACHINE")
>
>
>And, when we test from the test server, the parameter is adjusted to point to the main data source, such as:
>
>
> Dim loDT As New OleDbDataAdapter(tcSQL, _
> "Provider=VFPOLEDB.1;Data Source=f:\www\foxpro;Password='';Collating Sequence=MACHINE")
>
>
>But, when this is the case, the Web Service generates an error on that line saying that:
>
>Invalid path or file name
>
>However, f:\www\foxpro really exists if we test it manually from Visual FoxPro, for example. But, that drive is not visible from the Web Service.
>
>What should I do to resolve that?