My boss asked me to take one of our existing applications, which is written in C++ and connects to MS SQL Server, and get it to use connection pooling. I am new to connection pooling but I understand the general concept.
I found a helpful article,
Driver Manager Connection Pooling , that describes the functions that have to be called and how to call them in order for connection pooling to work. I found that the app already calls all of these functions correctly. I wrote my own small app that does
the same and I cannot get connection pooling to work.
(I know that connection pooling is not working because I am looking at the incoming connections using SQL Server Profiler. The "EventSubClass" column of the "Audit Login" event is "1 - Nonpooled".)
What should I be doing differently to achieve connection pooling?
Here is the test code I am using:
SQLHANDLE hdlConn1, hdlConn2;
View Complete Post