Differences

This shows you the differences between two versions of the page.

Link to this comparison view

crystal_reports_keeping_sql_connections [2019/01/27 11:29]
 crystal_reports_keeping_sql_connections [2019/01/27 11:29] (current)
Line 1: Line 1:
 +======  ======
 +
 +
 +
 +===== Question =====
 +
 +
 +
 +How do I prevent Crystal reports from keeping an open connection to SQL Sever after closing the report in Control? The connections are closed only after closing Control.
 +
 +
 +
 +===== Answer =====
 +
 +
 +
 +To force Crystal reports to close connections to SQL Server in Control:
 +  - Add this option to the Control startup options (Control shortcut, Options file, or registry): LogOffCrystalReports=1
 +  - If using Production Terminal, add the option to the SSLIP_Options file as well.
 +  - Restart Control and SSLIP.
 +
 +
 +
 +Notes:
 +  * The ODBC SQL connections mad for the reports will be closed after the report is closed.
 +  * Entered : 04/07/2010
 +  * Version(s) : Control 4.40.1004.0801+
 +
 +
 +