I was afraid of that, . . . I installed VFPODBC.msi (which I've downloaded) on a XP workstation, & now it works fine.
Thank you much Sergey!


>Inge,
>
>You've to install VFP ODBC driver on each XP workstations.
>
>>My .exe works fine on workstations with operating system other than the XP. My understanding is that XP does not come with ODBC driver installed. The .exe & data is on a network drive. I would like to avoid having to install ODBC drivers on all workstations. What can I do? (my own computer is an XP, but I guess I've downloaded & installed the ODBC driver -- I cannot remember, since the .exe works fine on my computer).
>>
>>Here's my code:
>>
>>lcConnStrSP="DRIVER={Microsoft Visual FoxPro Driver};" + ;
>>"SourceDB=&gSPPath.sp.dbc;SourceType=DBC;UID=;PWD=;"
>>
>>THIS.lnHandleSP=SQLSTRINGCONNECT(lcConnStrSP)
>>
>>lSuccess=SQLEXEC(THIS.lnHandleSP,"SELECT * FROM DA WHERE zYear='2003'","xDA")