>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?

Connection is a session.
Then, if you want hold a lock or a transaction open you have to maintain the session;
otherwise the design of the application pilot the choice.

However, to open a session is a process much slow one.

Fabio