Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Configuring ODBC Connections
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00462621
Message ID:
00463043
Views:
48
**************
>>Why not use a DSN-less connection to access the Access MDB. Here is an example posted by JVP some time ago:
lconnstr = 'DBQ=C:\Program Files\Microsoft Visual Studio\VB98\NWIND.MDB;'+;
   'DefaultDir=C:\Program Files\Microsoft Visual Studio\VB98;'+;
   'Driver={Microsoft Access Driver (*.mdb)};DriverId=281;'+;
   'FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;'
lnconn = sqlstringconnect(lcconnstr)
>>This way you can keep the conenction information in a table (or whereever) and add to it as needed.
>>
>>HTH.
**************
How would you rewrite this to connect to a vfp database? (just as a test in a system where local views are working fine).
Dr. Ken A. McGinnis
Healthcare software design
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform