• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1152
  • Last Modified:

How to use/insert in Crystal Reports 11.5 data-column with data-type:Picture (BLOB)

I use Crystal Reports 11.5. I connect to DB2 (IBM) in the backgroud. I connect successfully. I write a SQL to select * from table. Table has colum of type Picture (BLOB right?). When I try to insert field into report, I get error: "Failed to retrieve data from the database." (I click Ok) & then I get:"Database Connector Error: '0F001:[IBM][CLI Driver][DB2] SQL0423N  Locator variable "1" does not currently represent any value.  SQLSTATE=0F001  [Database Vendor Code: -423 ]'
I read that Crystal 11.5 allows you to work with BOLBs (Picture datatype  field).
Can I read and parse a Picture type field, or NOT?
And if I can/should, how do I do it?
Thanks
Joseph Hayon
0
Yossele
Asked:
Yossele
3 Solutions
 
Dave FordSoftware Developer / Database AdministratorCommented:

Hi Yossele,

Can you successfully return a non-BLOB into Crystal Repots?

( I always try to get the "simple case" working first ... before adding complexity. )

-- DaveSlash
0
 
mlmccCommented:
Agree.  It may also be that your connection method doesn't support blob data.

mlmcc
0
 
YosseleAuthor Commented:
Hi daveslash & mlmcc,
Thank you for your reply.
If a non-BLOB means any data type other that BLOB? The answer is YES.
After I posted the message. I tried something else. I connected my reorts to the NorthWind database, I found a column in table Categories, with a Picture type, and I was able to read it (display it on my Crystal Report canvas).
It might be the column definition by the DBA? I have to talk to him ...
Thanks for your participation
Yossele

0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now