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")
--sb--