Skip to Content
Former Member
Nov 27, 2009 at 06:34 AM

SQL Connections remain open after Crystal Report closes


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?