Skip to Content
avatar image
Former Member

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

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 code on which my Crystal Report is setup. Nothings seems to help.

Please Advise.


Madhusudan VS

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 23, 2017 at 09:01 PM

    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.


    Add comment
    10|10000 characters needed characters exceeded

    • 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 :)



  • Jul 26, 2017 at 01:08 PM

    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



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


    Add comment
    10|10000 characters needed characters exceeded