Skip to Content
author's profile photo Former Member
Former Member

SAPConnectionPool opening a new connection for every .GetConnection call


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?


Andrew Smith

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Nov 23, 2004 at 04:27 PM

    This should work. Can you post some code?

    BTW: Are you using version 2.0?

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.