Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP ODBC driver
Message
De
03/09/2019 12:01:39
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01670527
Message ID:
01670534
Vues:
61
>>>I was wondering where I can download the VFP ODBC Driver, I haven't seen it anywhere since a long time. Perhaps someone has an idea where I could still find it?
>>
>>FWIW use VFPOLEDB driver instead. ODBC driver is not supported since VFP 6.x.
>>
>>There is an ODBC driver from Sybase -ADS (not for free AFAIK).
>
>The problem with VFPOLEDB is, that I cannot query directly into a cursor, but ADO Dataset. When I have the dataset, I would need to create a cursor from that by loop and insert, but it's a huge table. So the only reason I used ODBC was that I can setup an async connection and get the result immediately, while scrolling and fetching continuously, so the user can start working without waiting for 5 minutes. But perhaps there is another way to use OLEDB that I have not considered?

You can use VFPOLEDB with cursor adapter, which makes it easy to use with a cursor and you can specify the fetch count (fetch how many rows at a time). Things are actually better than SPT IMHO.
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform