/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PublicSymptom
A severe performance issue is introduced when setting location to a Pervasive database when using the Report Designer SDK API ReplaceConnection or SetTableLocation
Environment
Crystal Reports 2008
Crystal Reports for Visual Studio 2010
Reproducing the Issue
Using the Report Designer SDK ReplaceConnection method.
See this knowledge base article on how to generate the code:
| 1553921 | Is there a utility that would help in writing database logon code? |
Cause
Crystal Reports SDK verifies the database
This was tracked - ADAPT01376800
Resolution
Located in the following locations is a file called: clientSDKOptions.xml
Crystal Reports 2008:
C:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 12.0\win32_x86
Crystal Reports for Visual Studio 2010:
C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\clientSDKOptions.xml
Modify the following tag to:
<VerifyDatabaseOnSetDataSource>false</VerifyDatabaseOnSetDataSource>
The default value is "true"
This issue has been resolved in:
-
Crystal Reports 2008 Service Pack 4
-
Crystal Reports for Visual Studio 2010 Service Pack 2
Keywords
Crystal Reports 2008, Crystal Reports for Visual Studio 2010, Pervasive , KBA , BI-DEV-NET , BI Software Development Kits (SDKs) - .NET or Other , Problem