Hello all,

I am looking for some suggestions. I am designing a VFP6 application front end for an Oracle8 database. I am currently accessing the database through Remote Views stored in a DBC that is created on the fly when the User Logs in. The problem that I am having is that it is just too slow.

I have experimented with using SQL Passthrough however by doing so I must write all of the INSERT,UPDATE, and DELETE statements in SQL rather than the native fox. Plus I cannot use parameterized views to return just the records that I need. I have to code each of these in SQL Passthrough.

The third thing that I have noticed is that the Oracle connection is only open when the views are in use. With SQL Passthrough the connection remains open until a sqldisconnect is executed.

What are you guys and gals using to connect your Oracle databases? Any help would be greatly appreciated.

Matt