SQL Client DB connection does not disconnect even after closing the crystal report.

[Former Member]

Hi ,

I'm currently using SAP Crystal Report 2013. I have a ODBC(RDO) connection setup and every time I run the Crystal Report from my native application(Progress 4GL Application), a new SQL DB connection gets established. However on closing the report, the SQL Client is not disconnected (i.e the connection still remains). Every time I open a report a new connection is established and it never disconnects until I close the application.

I tried using the .close() , .dispose() in VB.net code on which my Crystal Report is setup. Nothings seems to help.

Please Advise.

Regards,

Madhusudan VS

[former_member11696]

You say you are using Progress 4GL, is it using our CR .NET Assemblies? We don't have any other SDK for CR 2013, other than Java.

Enable CRLogger, add these to your System Environment variables and create the folder:

LOGGING_DIR = c:\logging

LOGGING_ENABLED_ASSERT = 1

LOGGING_ENABLED_RUNTIME = 30

Start the app up again and see what the logs show you when you close the report and then close the app.

Don

[former_member11696]

I believe its due to the nature of SQL Server, they now use Connection Pooling, you need to turn it off Server Side.

And upgrade tot he latest patch for CR 2013.

Don

[Former Member]

Hello Mr Williams,

Many thanks for the advise. I tried disabling the connection pooling in the ODBC configuration and installed CR2016. But It doesn't seem to release the SQLC connection when the report closes and to make things worse, A new SQLC connection is established every time I open a report.

I have shared you the screenshots of the ODBC Setup(Connection Pooling) and SQLC connection Details. Please have a look and share your feedback.

It would be of immense help 🙂

Regards,

Madhu.