Get the connection handle from a remote view for sqlexec()
lnHndl = cursorgetprop("ConnectHandle","remoteview")
sqlexec(lnHndl,...)
>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