SAP Knowledge Base Article - Public

1652169 - Failed to Open Rowset error when using CLOB data type

Symptom

  •  Connecting to an Oracle database
  • On preview of a report with a CLOB (Character Large Object) data field the following error is thrown:

Failed Open a rowset

Details:ADO Error Code 0x
Source Microsoft OLE DB Provider for Oracle

Description: Unspecified Error

Environment

  • Oracle
  • Crystal Reports - any version

Reproducing the Issue

  • In the Crystal Reports designer log on to an Oracle database - using MS OLE DB provider
  • Select a table containing the CLOB data field
  • Place the CLOB field on the report
  • Preview the report

Cause

  • Microsoft OLE DB Provider does not support CLOB field types
  • For more information see Microsoft KBase q244661

Resolution

  • Use Oracle OLE DB provider
  • Use ODBC
  • Use datasets

Keywords

DBCLOB double byte memo unicode text Binary Large Object blob , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports XI R2 ; SAP Crystal Reports, developer version for Microsoft Visual Studio ; SAP Crystal Reports, version for Visual Studio .NET 2005 ; SAP Crystal Reports, version for Visual Studio .NET 2008