General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
OLE DB and remote access
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only