Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OLE DB and remote access
Message
From
13/06/2002 09:33:52
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
OLE DB and remote access
Miscellaneous
Thread ID:
00667896
Message ID:
00667896
Views:
59
Using VFP7 and it's OLE DB provider, is it possible to access a VFP7 data source remotely?

This example will work:
oconn = CREATEOBJECT("adodb.connection")
OConn.ConnectionString = "provider=vfpoledb.1;data source=c:\mydir\mydbc.dbc"
OConn.Open

But what if the VFP database resides in a remote location. Is there some way to connect to the database via a IP address?

I tried the following but without success:
oconn = CREATEOBJECT("adodb.connection")
OConn.ConnectionString = "provider=vfpoledb.1;data source=http://myip/mydir/mydbc.dbc"
OConn.Open

Is there a way to query a VFP database remotely?

Thanks,

Jerryt
Next
Reply
Map
View

Click here to load this message in the networking platform