Basically I have this problem. I'm building a COM object on a website , accessing foxpro databases and tables .. no problem at all .. unfortunately I also need to access some other foxpro data living at a separate URL ,unconnected, except it is accessible through the net.
Currently I'm using a connection string like:
cConnection="Provider=VFPOLEDB.1; Remote Server=http://MyServer.com; Remote provider = VFPOLEDB.1; data source=C:\INETPUB\WWWROOT\DATA\TESTDATA.DBC"
oCon=CREATEOBJECT("ADODB.Connection")
oCon.Open(cConnection)
This never works .. I always get "Invalid path or filename". WebSharing in the directory in question is turned on.
Now, both machines in question have VFP7.0 installed and have the Visual Foxpro OLEDB Provider driver VFPOLEDB loaded. I can access data locally without any problems. For testing, I'm using a Win ME machine with just Personal Web Server installed as the remote.
First of all, can I actually do this ? Can you access remote Foxpro tables on another machine through the net? I have seen some really good examples for connecting to remotely sited SQL SERVER databases .. but none for Foxpro ..
If so, what do I specify as the "Remote Server" ? Is it the URL of the remote machine? I have tried using the "URL" argument in place of "Remote Server"
eg.cConnection="Provider=VFPOLEDB.1; URL=http://MyServer.com; Remote provider = VFPOLEDB.1; data source=C:\INETPUB\WWWROOT\DATA\TESTDATA.DBC"
This doesn't work either ..
Mega thanks in advance for any insight provided
Rob Gordon
rgordon@galavu.com