Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. CKG Edit ====== ====== ===== 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+