SAPConnectionPool opening a new connection for every .GetConnection call

[Former Member]

Hello

I am trying to use the SAPConnectionPool class to improve the performance of a Web application I am maintaining.

My understanding is that all I should have to do is use the Static GetConnection and ReturnConnection functions and, as long as the connection strings are the same, the connction pool should re-use an existing, returned connection rather than creating a new one. However the SAPConnectionPool is currently creating a new connection for every GetConnection call. Any suggestions?

Regards

Andrew Smith

[reiner_hille-doering]

This should work. Can you post some code?

BTW: Are you using version 2.0?

[Former Member]

Hello

You're right, it should, and it does. Calling .Open on a connection from the connection pool is obviously not the best idea...

Dunce hat is firmly in place ;o)

We are still using Version 1. has version 2 been officially released? if so, how much effort is required to port existing code to version 2?

Regards

Andrew Smith

[reiner_hille-doering]

NCo 2.0 is released since end of Septembre. It should be almost 100% source code compatible - so it should be sufficient to uninstall 1.x, install 2.0, click "Run Custom Tool" on .sapwsdl file and recompile. Please note my WebLog /people/reiner.hille-doering/blog/2004/10/04/more-sap-net-connector-20-news , FAQ, and OSS note 506603.