OLE DB should be faster than ODBC. If you are having performance problems, then something isn't right with your configuration. What does your OLE DB connection string look like?
>Wich is the best way to construct a report based on multiple join Query between VFP Tables and obtain good performance. The Tables have aprox. 1GB of physical size. Actually we are using ODBC Connection, I have tried with OLEDB.. the performance is not good. Wich one do you recommend???. Do I have to build a query cursor and then copy to fox2 table??... that means I have to create a table with same structure as cursor in some place to construct and design the report... and make changes in report, cursor, and table each time when I add or remove fields to display in the report?
>
>Any suggestion?... Thanks,
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer