>I am using both remote views and spt in my application. I have several questions about connections:
>
>1. If I have a form using remote views and they are all configured to share connections, is only one connection opened?
>
>2. Are RV connections 'scoped' to a datasession i.e will they close when the datasession is closed? What about spt connections?
>
>3. Is it more efficient to close a spt connection as soon as you are finished using it e.g. populate the rowsource of a combobox? If the rowsource needs to be requeried should you reopen a connection or keep it open until the form closes?
>
>4. How do you share spt connections (do you need to)?
>
>TIA
>
John,
Just to give you some more information and assuming this is SQL Server you're talking about, regardless of how many connections an application has to the backend, only one license is used. SQL server uses the MAC address to determine whether to increment or decrement the license count.
George
Ubi caritas et amor, deus ibi est