>>>>Could anyone please point me to the link to download VFP Oledb provider?
>>>
>>>You can get it with VFP7 only. There's no separate download available.
>>
>>Thanks.
>>
>>Now, I installed VFP 7.0 but having problems accessing free tables? I think I can't find the proper syntax for the connection string to access free tables. Here is what I tried and didn't work.
>>
>>oConn = CREATEOBJECT("ADODB.Connection")
>>oConn.ConnectionString = "provider=vfpoledb.1;data source=c:\temp\"
>>oConn.Open()
>>
>>oConn.Open() returns NULL. What am I doing wrong?
>
>It always returns Null. You'll get an error if it cannot open connection.
>
>BTW, don't forget to install SP1 for VFP7.
I have installed SP1...There is no error when I open the connection but when I open te Recordset using this connection, RS.RecordCount returns -1....
Thanks again...
- Jayesh