Friday, April 15, 2011

Error while retrieveing BLOB field from database?

Hi all.

I'm trying to retrieve a BLOB field from Oracle and show it in a crystal report. While viewing the report, I've that error:

Failed to open a rowset.
Details: ADO Error Code: 0x
Source: Microsoft OLE DB Provider for oracle
Description: Unspecified error

I use a View as report datasource, its script

SELECT COMPANY_ID, COMPANY_LOGO FROM ID_COMPANY_SETUP;

I'm using CrystalReport embedded with VS.NET 2005.

Any suggestions?

From stackoverflow
  • I got where was the problem. It was "Connection Type".

    I were using OLE DB(ADO) for connection to database, while I changed it to Oracle Server connection, blob field retrieved properly.

0 comments:

Post a Comment

Note: Only a member of this blog may post a comment.