Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need to install ODBC driver on every XP workstation?
Message
From
30/10/2003 17:33:09
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Need to install ODBC driver on every XP workstation?
Miscellaneous
Thread ID:
00844753
Message ID:
00844753
Views:
44
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")
Next
Reply
Map
View

Click here to load this message in the networking platform