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.