RayBakker
asked on
SAP Crystal Reports 2016 not disconnecting from SQL Server 2012
Greetings
I have inherited some code from a colleague and I noticed that the SAP Crystal Reports are not disconnecting from the SQL Server. The application does close and dispose of the crystal viewer instance. I have posted the code here:
I my attempts to resolved the issue, I also added this:
I also found that the issue may be with SQL Server and Connection Pooling, so I added this to the connection string:
Pooling=False
I do not see an increase in memory usage on the application server. But I do see that the connections to the database on the database server does not decrease after the application is closed.
Does anyone have any other suggestions?
I have inherited some code from a colleague and I noticed that the SAP Crystal Reports are not disconnecting from the SQL Server. The application does close and dispose of the crystal viewer instance. I have posted the code here:
Private Sub CloseCrystalReports()
If CRReports.crRpt IsNot Nothing Then
CloseReports(CRReports.crRpt)
CRReports.crRpt.Close()
CRReports.crRpt.Dispose()
CRReports.crRpt = Nothing
End If
GC.Collect()
GC.WaitForPendingFinalizers()
GC.Collect()
End Sub
I my attempts to resolved the issue, I also added this:
Protected Sub Page_Unload(ByVal sender As Object, ByVal e As EventArgs)
If CRReports.crRpt IsNot Nothing Then
CloseReports(CRReports.crRpt)
CRReports.crRpt.Close()
CRReports.crRpt.Dispose()
CRReports.crRpt = Nothing
End If
GC.Collect()
GC.WaitForPendingFinalizers()
GC.Collect()
End Sub
I also found that the issue may be with SQL Server and Connection Pooling, so I added this to the connection string:
Pooling=False
I do not see an increase in memory usage on the application server. But I do see that the connections to the database on the database server does not decrease after the application is closed.
Does anyone have any other suggestions?
ASKER
Ido
Thanks for the quick response. I looked at the References and the CrystalDecisions.CrystalRe ports.Engi ne is version 13,.0.3500.0
Ray
Thanks for the quick response. I looked at the References and the CrystalDecisions.CrystalRe
Ray
Look at installed features. Find
SAP Crystal Reports runtime engine for .NET Framework (32-bit)
Look at the version.
The SP number is the 3rd component.
For example, 13.0.24.2970 is SP24
SAP Crystal Reports runtime engine for .NET Framework (32-bit)
Look at the version.
The SP number is the 3rd component.
For example, 13.0.24.2970 is SP24
ASKER
Ido
I forgot about the server. We are currently running 13.0.22.2668 64 bit on the server. So we should be good.
I forgot about the server. We are currently running 13.0.22.2668 64 bit on the server. So we should be good.
Does the problem go a way if you use ODBC instead of OLEDB?
ASKER
Ido
I think I have found a solution.
I the report its self,Under Database > Set Datasouce Location, under properties, set OLE DB Services to -4.
Seems to have resolved the issue. I will continue to test. I will post back on Monday. Keep you fingers crossed.
Ray
I think I have found a solution.
I the report its self,Under Database > Set Datasouce Location, under properties, set OLE DB Services to -4.
Seems to have resolved the issue. I will continue to test. I will post back on Monday. Keep you fingers crossed.
Ray
Excellent. Thanks for closing the loop.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Upgrade the runtime to SP22 or later and the problem should go away.