Hi Jojo
>What if you stored your connection handle during your app startup and just close the handle on exit or on your forms load & destroy procedures but then your network connection link is broken or your SQL server just experience a problem and it goes down? This means that your connection handle is useless and not valid anymore.
>
>What do you think? Am I wrong with my BEST PRACTICE?
I really don't know what to say as I myself was in the dark. But then I guess we can have best of both the worlds. Store the connection as suggested by others. Before any action confirm the Stored Handle using a small SQL SELECT or some very low bandwidth SQL statement.
What do you say on this method?