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