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

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 2013

Crystal reports for Visual Studio

Cause

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

Resolution

The Product Group has agreed to allow users to define this property in the connection Wizard of CR Designer and embedded CR Designer in Visual Studio

Work around for now is to use a 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