I'm trying to access VFP data from VFP using OLEDB. Here is my code in the command window:
OConn = Createobject("ADODB.Connection")
oRS = Createobject("ADODB.Recordset")
OConn.ConnectionString = "provider=vfpoledb.1;data source=myData"
myData is a .DBC or a free table
?OConn.Open()
This always returns .NULL.
?oRS.Open("Select * from myTable",OConn)
This returns:
1. NULL if the myData is a DBC and myTable is a table in the myData
2. OLE exception error c00000005 if myData and myTable are a free table
I hope it's the syntax, but I'm afraid it's just nonsense and I need to RTM first?
Doru