1757244 - Crystal Reports .NET SDK verifies the database when updating the database location to a Pervasive database

Symptom

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

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports, developer version for Microsoft Visual Studio