Arun Narayanan
Jun 16th, 1999, 06:29 PM
Hi,
I have developed a program in VB6 which monitors a directory periodically. It then updates an application database on MSSQL-Server6.5. The database access is encapsulated in an ActiveX DLL.
The DLL sets its own connection and talks to the database. So each time the DLL is accessed a connection is established.
My questions are:
1. Is this the best way to do so ?
2. I would like to isolate the data access methods so that I can use the same logic ( DLL ) in other applications. Basically I am trying to separate the GUI and the Database code.
All help is appreciated and thanked
I have developed a program in VB6 which monitors a directory periodically. It then updates an application database on MSSQL-Server6.5. The database access is encapsulated in an ActiveX DLL.
The DLL sets its own connection and talks to the database. So each time the DLL is accessed a connection is established.
My questions are:
1. Is this the best way to do so ?
2. I would like to isolate the data access methods so that I can use the same logic ( DLL ) in other applications. Basically I am trying to separate the GUI and the Database code.
All help is appreciated and thanked