Skip to Content
0

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

Jun 23, 2017 at 04:42 PM

128

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Don Williams
Jun 23, 2017 at 09:01 PM
0

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

Show 1 Share
10 |10000 characters needed characters left 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 :)

Regards,

Madhu.

0
Don Williams
Jul 26, 2017 at 01:08 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded