Yeah all the views are shared - however there are some SQLEXEC commands that might be doing it....
>Make sure that all your views are using the same connection. If you have a login screen, you need to make sure that connection is shared as well. This is the reason why I quit using remote views. SPT and cursor adapters are much easier to manage the connections.
>
>
>>All my views have ShareConnection = .T., but I still get 6 connections....weird.
>>
>>>Yes. ShareConnection = .f. will create a new connection for each view.
>>>
>>>>Today my users started getting an Oracle ODBC error which says "maximum number of processes exceeded.
>>>>
>>>>It looks like each of my users is getting 6 connections to the backend somehow & I'm wondering why this is happening.
>>>>
>>>>1. I notice that a few of the remote views have ShareConnection set to .F. - should I set all of these to .T. ???
>>>>2. What is best to use for the Asynchronous setting?
>>>>3. Any other suggestions?
>>>>
>>>>Thanks!
>>>>-Victor Anderson
ICQ 10556 (ya), 254117