>Hi,
>
> Normally i make a connection as follow :
>
> 1) Open one connection to the database and reuse the connection all the time until i exit the system.
> 2) Open connection to the database, close the connection when the query finish, reopen again the connection for another query and close it when finish.
> May i know which one is better for performance and which one is suggested to be used and what is the pro and cons?
>
>
>Thank you very much.
>regards,
>
>florence
Reuse it - if it breaks, the result handle of your SQLEXEC() will return a negative - or fire your Error routine.