I had the same problem before, I wanted to use the DSN-less connection. But for some reason, it's not working on some machine. And it will work after I setup the DSN, and connect with SQLStringConnect function. And I am still seeking for the reason. Keep me in the loop.

Thank you and sorry that it didn't help.






>No, I'm using DSN-less connection.
>
>
>
>>Have you setup a System DSN for this connection?
>>
>>
>>
>>
>>>lcConnStrAUSD="DRIVER={Microsoft Visual FoxPro Driver};" + ;
>>>"SourceDB=C:\Projects\mydata.dbc;SourceType=DBC;UID=;PWD=;"
>>>
>>>lnHandle=SQLSTRINGCONNECT(lcConnStrAUSD)
>>>
>>>lnHandle gives me -1 (no connection to database) after I moved my files into my new computer (Windows XP). It used to work fine on my Windows 98 computer. What could be wrong?
>>>
>>>Thank you all!!!