>>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