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:
00463453
Views:
35
>*****************
>
>lcconnstr = 'Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;' + ;
>>   'SourceDB=C:\MyDir\Mydatabase.dbc;Exclusive=No;Deleted=No;' + ;
>>   'BackgroundFetch=No;'
>>lnconn = sqlstringconnect(lcconnstr)
>>HTH.
>**************
>This would allow the use of remote views. Do you know if the access times would be significantly slower than with local views for tables having 80K - 15 million records?

I believe it would be because you are adding the extra overhead of the ODBC driver insetad of the native VFP data engine.
Larry Miller
MCSD
LWMiller3@verizon.net

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

Click here to load this message in the networking platform