Ric,
See if
PRB: ODBC Error Message 1526 - "Connectivity Error" mskb #
Q239714 applies to your situation. I would also try to download and reinstall VFP ODBC driver.
>Sergey,
>
>I am using W98; driver version 6.01.8629.01.
>
>>Ric,
>>
>>Looks like problem is with VFP ODBC driver itself. What's the version of VFP ODBC driver you're using. The latest one is 6.1.8629.1. What WIndows version are you running?
>>
>>>Hi Sergey,
>>>
>>>I have tried yours and get this:
>>>
>>>*-- AERROR RETURNS:
>>>*-- [1] 1526
>>>*-- [2] "Connectivity error: [Microsoft][ODBC Visual FoxPro Driver]Function sequence error"
>>>*-- [3] "[Microsoft][ODBC Visual FoxPro Driver]Function sequence error"
>>>*-- [4] S1010
>>>*-- [5] 0
>>>*-- [6] 5
>>>*-- [7] .NULL.
>>>
>>>I have tried many directories, and sqlstringconnect, sqlexec, etc... so now I am really stumped.
>>>
>>>Ric
>>>
>>>>Ric,
>>>>
>>>>My guess is, that something's wrong with DSN configuration. Did you try to access the same directory with code I provided in another message in this thread? Did you try to access another directory with free tables?
>>>>
--sb--