SAP Knowledge Base Article - Public

2097804 - ER - Add Application Name property in OLE DB Provider in CR Database Wizard for MS SQL Server to customize the name when viewing in SQL Profiler

Symptom

Enhancement Rerquest (ER)

When tracing Crystal Reports database SQL sent to MS SQL Server using Profiler the log shows "Crystal Reports...."

Environment

Crystal Reports Designer 2011 SP 11

Crystal Reports Designer 2013 SP 6

Crystal Reports Designer 2016

Crystal Reports developer, for Visual Studio SP 13

Cause

Currently this "Application Name" property is harded coded and will ignore any custom setting.

Resolution

For an unknown reason we did not change this to allow setting it in code, doing so removes the existing value.

The work around is to set it in the connection property in CR Designer or use an OLE DB UDL or ODBC File connection and specify the property there.

Keywords

Crystal Reports, Database Wizard, OLE DB, Application Name, cr for vs , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , BI-RA-CR-SDK , SDK related, including Java/.NET etc. , Product Enhancement

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports, developer version for Microsoft Visual Studio