I am connecting to SQL 7.0 in my case. And I am connecting it thru TCP/IP.
lcConString = "driver=SQL Server;Server=100.100.0.1;database=dbase;uid=username;pwd=userpassword;Network Library=DBMSSOCN;"
Thank you for your suggestions.
>>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.
>>
>
>Usually the improper installation of the VFP ODBC/OLEDB driver - it is not part of the base distribution with XP.