Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP ODBC driver
Message
From
03/09/2019 09:36:18
 
 
To
03/09/2019 08:13:16
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01670527
Message ID:
01670532
Views:
50
>>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?
Christian Isberner
Software Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform