Hi Piter,
The article 'ADO Jumpstart for Microsoft Visual FoxPro Developers' by John Petersen should get you started http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfoxgen/html/adojump.asp.

>Yes, when I got to work this morning it worked here too- not that I did anything to fix it- spooky huh? :-))
>
>As far as OLEDB is concerned, I really don't know jack .... about it, and I don't have the time to delve into it just now. Would like to, though, so if there is any relevant literature out there please let me know. The VFP help on the subject seems a bit terse.
>
>Anyway, thank's for helping out and chipping in guys.
>
>
>>It didn't work because I had DBC Events turned on. After I turned them off ODBC works fine. Check your DSN configuration. Maybe something wrong there.
>>
>>>I seems to remember that I couldn't connect under WIN2k. I'll check it tonight.
>>>
>>>>It's W2000.
>>>>
>>>>BTW, I did set events off, so now I still can't connect, only now I get a different error.
>>>>
>>>>From the AERROR array:
>>>>
>>>> element 2,3= [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
>>>> element 2,4= IM006
>>>>
>>>>Peter
>>>>
>>>>
>>>>>WWhat version of windows are you running?
>>>>>
>>>>>>>Hi Peter,
>>>>>>>
>>>>>>>You have the latest VFP ODBC driver but you cannot acces database thru it if DBC events are enabled. The VFP ODBC driver doesn't support DBC events. You can access such DBC only thru OLE DB profider for VFP. The ODBC should work if you turn DBC events off.
>>>>>>>
>>>>>>>>And if there is, where is it?
>>>>>>>>
>>>>>>>>When connecting to VFP7 databases I get an error saying
>>>>>>>>
>>>>>>>>"Connectivity error: [Microsoft][ODBC Visual FoxPro Driver]File was created in a later version of Visual FoxPro than the current version."
>>>>>>>>
>>>>>>>>This I guess is true, because I have VFPODBC.DLL 6.01.8629.01 from december 12, 1999 installed.
>>>>>>>>
>>>>>>
>>>>>>Hi Sergey,
>>>>>>
>>>>>>I think 'should' is the operative word here- I have looked in the DBC and events are off, nevertheless I get the error. I guess I'll just ´have to create the DB in VFP6?
>>>>>>
>>>>>>Thanks for your help, though.
>>>>>>
>>>>>>Regards