Storing Pictures in Database

[Citra]

I'm using oralce 9i as my backend.

I wish to store pictures, for that I'm having a field in my table as BLOB.

Using ADO Connectivity, But while opening the recordset as "select * from tablename" produces error "Unspecified Error"

How can I solve it?

 

[CCLINT]

Try using the GetChunk method: thread709-391834 and thread222-541549

Check out MS Knowledgebase articles for problems with Blob data and Oracle:
Q239719 Q185958 Q192743 Q201236

You can also do a search there on the keywords: Oracle and Blob

 

[zemp]

A common alternative method is to store the path to the picture in the database as a string. Then you can store the picture almost anywhere you like and don't need to deal with pictures or images in your database. The picture is then loaded from a file on the hard dirve via the stored path.

Thanks and Good Luck!

zemp