You can download the ODBC driver from VFP's web site:

http://msdn.microsoft.com/vfoxpro/downloads/addons/odbc.asp


>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.