SQL Connections remain open after Crystal Report closes

[Former Member]

I am wirting an interface to use the crystal report viewer to print reports, connecting to a Progress Open Edge 10.1B database. From our application we declare the application, report, exportoptions and connectionproperties objects and pass these to the crystal reports viewer. Once the report is printed we release the objects and set their variables for null. However we are finding that the SQL connection to the database is remaining connected and we can only release the connection by manually going in a disconnecting.

I have read in forums that people use .dispose or .close to release the connection, however we do not have access to these methods as we do not use .NET. Are there any methods we can use to disconnect these sql connections?

[former_member11696 · Accepted solution]

Hi Dean,

Moved to the Legacy Application forums. Likely using the RDC as your report engine.

You should still be able to close and dispose of the report objects. They are not specific to .NET.

In VB it would look something like these lines::

crReport.Close

Set CrystalActiveXReportViewer1.ReportSource = Nothing

Set crReport = Nothing

Once the report is closed it should disconnect from the DB. If you close the application does that disconnect?

Have you looked on 4GL's site for info on how to?

Thank you

Don