Peter,
Works under w2K. Probably you're trying to reuse an active handle or trying to set mode after connection made.
Where and how do you call this ?
Cetin
>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