Try using FoxOleDB with Oracle's OleDb Drivers, insted of ODBC (FoxOleDB is much faster). Use the interface that this control provides, that BTW is very similar to SqlPassThru.

To use FoxOleDb you will need to generate a Connection string (The MS ADO component may assist you on this). So far this tool has worked very well for us!

Regards.


>> Hi, i'm trying to convert a VFP Aplication that Runs its Database in SQL Server to a VFP Aplication that con have its database in Oracle or SQL, i can connect to Oracle via ODBC, but i can't create the remote Views, i get the Error "No Result Set has been returned from the server" can anyone tell me how can i create the remote views, or how can i get VFP to Interact with Oracle 8i???

Thankz