Hi Mike,
>I've had similar problems using an Oracle back-end. When I change my views to share a connection I get errors when the dataenvironment inits.
the best way is to create the connection when your application loads up. The views could be based on this connection and that will help in speeding up the loading of views (i.e. forms)
VFP's native behaviour for remote views is:
- Establishes the connection when you load the views if the connection does not exist
- 2ndly when you unload your form it disconnects the connection if no other view in other form is using the same connection
So if a user is just using one form then the connection is established when the form is loaded and released when the form is unloaded. The cost of establishing a connection (in time) is expensive.