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? *** END QUOTE *** We'll the other suggestions are good, and your method is a nice idea. My practice of connecting and disconnecting when doing an insert,update, delete or queries was base on my web database application development which I also practice in my VFP programming when it comes to Client/Server application.
But normally database servers are reliable, so storing your connection handle during startup of your app is no problem. Actually it will speed up during your process since your not going to initiate a connection to your remote database server from time to time. Stick to what best to your application requirements.
Jojo R. dela Cuesta, B.Sc. eConsultant, Programmer Dalplus Technologies http://www.dalplus.com
