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

[Former Member]

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.

[former_member11696]

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