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

CRYSTAL REPORTS 2013, SQL CONNECTIONS ARE NOT BEING RELEASED AFTER CRYSTAL REPORTS IS CLOSED.

Hello,

Good Day!

I am using SAP Crystal Reports 2013. When we connect the SAP Crystal Report 2013, Using ODBC SQL Client, SQL Client Connections are not being released after closing the Crystal Reports. We tried multiple ways, I could not find any solution. Can you please guide me to resolve this issue.

Thanks in Advance,

Philip.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 21, 2016 at 01:01 PM

    Hi Philip,

    Where are you seeing the connection still open?

    What patch version of CR are you using?

    You should try the latest, we may have change the default behaviour, see below for more info.

    When CR is closed we do send a disconnect to the client. What I believe you are seeing is the new Connection Pooling feature of SQL Server.

    MS SQL Server implemented this function so when an app makes a connection it pools that connection so if another app requires connecting it will use it rather than opening a new one.

    CR doesn't use that ability so it makes a new connection when required.

    Check with Microsoft and their Forums on how to disable it.

    Also, you should be using MS Native 10 for SQL 2008 or Native 11 for SQL 2013 or above.

    Don

    Add a comment
    10|10000 characters needed characters exceeded

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.