I wish to wirte an ActiveX exe that handles my connection pool. Does anyone know where I can get hold of an example of this. I have heard that the MDAC Pooling ToolKit contains one but I can't find the toolkit so directions to this would also be appreciated<br><br><br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ADO Connection Pooling
- Thread starter Vince
- Start date
Karl Blessing
Programmer
I belive the connection pooling of ADO is automatic, because it keeps some connections open for those who need to connect after someone has disconnected. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href= </a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML,Visual InterDev 6, ASP(WebProgramming), QBasic(least i didnt start with COBOL)
I'm definately *not* personally an expert on this subject, but my understanding is that conventional connection pooling is handled by MTS (transaction server).<br><br>We elected not to use MTS because of some issues specific to our environment. In order to reduce the considerable performance hits when connections are established, we open 2 connections for each user/workstation at sign on and keep them open until sign off. We use one connection for interactive tasks and the other for batch postings. I regard this as an unconventional architecture, but it has been beautifully effective for us. <p>John Kisner<br><a href=mailto:jlkisner@jlkisner.com>jlkisner@jlkisner.com</a><br><a href= > </a><br>
Karl Blessing
Programmer
Connection pooling is inside of ADO, you never use MTS unless you actually create an MTS enviroment. ADO connections, will keep a connection idle until a new user hops on, this just keeps speedy access onto the database going. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href= </a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML,Visual InterDev 6, ASP(WebProgramming), QBasic(least i didnt start with COBOL)
RaghuramJoshi
Programmer
As documented by Microsoft, connection pooling is a property of ODBC driver and not of ADO. Yes, MTS does connection pooling automatically but then you don't need MTS for every application.<br>As such it is very difficult if not impossible to simulate connection pooling using a component. <br>
Karl Blessing
Programmer
I kind of meant the same thing Rag. (ADO -> ODBC Driver) <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href= </a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML,Visual InterDev 6, ASP(WebProgramming), QBasic(least i didnt start with COBOL)
- Status
Similar threads
- Locked
- Question
