1201984 - ADO.NET (XML) option is unavailable in Database Expert of Crystal Reports

SAP Knowledge Base Article - Public

1201984 - ADO.NET (XML) option is unavailable in Database Expert of Crystal Reports

Symptom

  • Missing ADO.NET option in Database Expert of Crystal Reports
  • Unable to connect to ADO.NET datasources

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. Open Crystal Reports Designer
  2. Click Standard Report Wizard
  3. Double click Create New Connection
  4. ADO.NET (XML) option is not there

Cause

ADO.NET (XML) option requires .Net Framework 2.0 to be installed on the machine

Resolution

Install .Net Framework 2.0 or 3.5 which includes the 2.0.

Note: .Net Framework 4.5 is not enough, you still need .Net Framework 3.5, see below working example for Windows Server 2012:

 

NetFrameworkW2012Server.JPG

Keywords

ADO.NET (XML), ADO.NET, ADO.NET option not available, Unable to see ADO.NET , not found, 521505 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2