General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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!!!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only