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