>I am using VFP6 as the front end to a 3nf Oracle 8.5 database. I know that there are no really good tools for normalised data, but VFP is the best. Anyway, for each table used in a form VFP creates a new session, so that when in the master data form, there are 18 open sessions, and when a sub-form gets called, yet another session gets opened. Is there any way I can get VFP to only create 1 session per instance? While debugging the app I keep running out of sessions on the Oracle server. As there will be up to 20 concurrent uses of the app when it rolls out, I must keep the connection count down.


I presume you are using remote views for your access. In this case, there is a property in the view definition (advanced options from the query menu) that allows you to set the check box - share connection. By default, this is NOT checked but it should be! Use the same connection for all remote views, and mark them all as sharing the connection.

If you are using SQL passthrough, you should only have the one connection object to use anyway.