Board index » delphi » About ADO Connections and DLLs
About ADO Connections and DLLs
2006-01-19 12:06:26 AM
This is an interesant question :)
I have Delphi 2006. I am programming "extensions" to a main application that
is made by another corporation in VB.
And I made it fine. Works beautiful.
The extensions are all DLL. The main server: Microsoft SQL 2000 Server.
It's fine. All works fine.
Every extension is a DLL. Every DLL has a lot of units. And ONE Data
Module -i love this-.
But I am very worried about the following.
All DLL's have lot of procedures inside, and sometimes one calls each other.
Every procedure create one instance of the Data Module and the DataModule
creates a SQL connection.
So, every connection consumes one license on the SQL server.
I would like to create one DLL for the connection with the server and I want
that all my DLLs uses that "dll connector" to work. is this possible? how?
If the ADO Connection component is inside this "DLL connector" , How can
the-others-DLL access to this ADO Connection?