>>>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.
--sb--