About ADO Connection ?
-
Hello ! Which is better ? *** Create one ADOConnection at start point, and use it globally in program or *** Create an ADOConnection whenever and everywhere needed :confused: tanks ;)
Create an ADOConnection whenever it's needed.
-
Hello ! Which is better ? *** Create one ADOConnection at start point, and use it globally in program or *** Create an ADOConnection whenever and everywhere needed :confused: tanks ;)
Is better to use the adoconnection like a global variable for your application, but you must open the adoconnection when you need, and leaving that connection open, for future use, and closing the connection when you close the Applictaion. But if your applictation need to use the connection every a long time, is better open the connection every time that you needm, but always leaving the connection like a global function. Cheers.... Carlos Antollini.
-
Create an ADOConnection whenever it's needed.
-
Is better to use the adoconnection like a global variable for your application, but you must open the adoconnection when you need, and leaving that connection open, for future use, and closing the connection when you close the Applictaion. But if your applictation need to use the connection every a long time, is better open the connection every time that you needm, but always leaving the connection like a global function. Cheers.... Carlos Antollini.
-
Hello Carlos Antollini .... ;) your answer is good, too ! but, I have problem with that when I use Transaction with Option_Explicit set to ON. In some cases i should restart my application.
You are working with VB? :-D Regards!!!! Carlos Antollini.
-
You are working with VB? :-D Regards!!!! Carlos Antollini.
-
I'm Sorry, I don't Know Nothing About Delphi.... But If you use the Connection like a Global Variable, You don't must to forguet to close the connection, when Close the Application. For other part, I don't Know what happens in Delphi. I'm Sorry Again.... Best Regards!!!!:-D Carlos Antollini.
-
I'm Sorry, I don't Know Nothing About Delphi.... But If you use the Connection like a Global Variable, You don't must to forguet to close the connection, when Close the Application. For other part, I don't Know what happens in Delphi. I'm Sorry Again.... Best Regards!!!!:-D Carlos Antollini.