Thanks Sergey for your reply on my previous question regarding SQLSTRINGCONNECT (see below). In the future, we are going to be using SQL Server to replace our VFP databases. I thought that using the connection string & the SQLSTRINGCONNECT command is the best way to go, since I like to have a DSN-less connection so that I do not have to worry about going to each user's computer to set it up. But since XP does not come installed with the ODBC driver needed to make this happen, I was just wandering about the future of this approach. Should I be considering some other way to connect to my databses? If so, what & how?
Thank you all!!!!
>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!!!
Sergey replied:
Windows XP doesn't have VFP ODBC driver installed. You can download it from
http://msdn.microsoft.com/vfoxpro/downloads/addons/odbc.asp.