>>Is it a better practice to establish a remote connection why an app starts and leave the connection static until the app ends?
>>
>>Or
>>
>>Make connections on the fly and do the various SPT statements need their own connection handle?
>
>I'd think the latter would be almost always preferred. However, what the backend is could be a critical. If it's SQL Server you'd need a license for the maximum number of simultaneous connections (I *think* I have the correct.

Hi Nancy,
Fortunately it is incorrect.
License is for cpu or for device or for user.
Total connections are bounded to 32K.

Fabio