Hi Josh,
Thank you for the advice. It sounds like good solution for the application I am currently working on.
>I've found the VFP ODBC driver to be pretty slow, too. You may want to use an approach I've used successfully in the past. You write a function that executes all your SQL statements. You then pass SQL statements to the function. The function decides whether to execute the statement directly with macro expansion or passes it to the ODBC driver with SQLEXEC(). You can use a global variable or application object property to specify what data source is being used.
>
>>Hi Josh,
>>
>>Thank you for the reply.
>>In my application I use only SQL Pass-through. Regarding the first option, I tried to use VFP ODBC driver and it gives poor perfomance, comparing with native VFP tables. What are other problems that you know about the driver?
>>Is it stable enough to rely on? Do you have information how to optimize perfomance of data access for the driver?
>>
Igor Gelin
Database Developer