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:
00463062
Views:
29
lcconnstr = 'Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;' + ;
   'SourceDB=C:\MyDir\Mydatabase.dbc;Exclusive=No;Deleted=No;' + ;
   'BackgroundFetch=No;'
HTH.

>**************
>>>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).
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform