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?