MTS Connection Pooling

[ksutton]

Can someone please provide me a sample program to test connection pooling with MTS/COM+. I am trying to verify how it works, but am new to MTS.

My small test EXE and DLL do not work as intended. When monitoring through SQL Perf Mon, I can see the number of connections increase each time that I click the command button to have a connection opened again.

Any help is GREATLY appreciated!!!!!

Thanks,
Kevin
kevin.sutton@ps.ge.com

[baroberts]

In your code, make sure you:
1) establish the connection
2) use it
3) close it(setting the connection object to "Nothing", too). This should work.

[Clunietp]

Usually, the number of connections will increase (up to 3-5 concurrent connections or so) and then should level off. You should monitor your server with the SQL Server Profiler and look for the ExistingConnection events to happen. This lets you know that connection pooling is enabled and happening.

There are other reasons why this won't work (assuming its not). Are you calling SetCmplete in your MTS objects? Are you using the native OLEDB provider? What MDAC version on the MTS Server?

If you just post your MTS method code, that should be sufficient enough for us to see what's up with it...


Tom