Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
How to access BLOBs from database
Old 10-18-2005, 08:27 AM How to access BLOBs from database
tcb
Experienced Talker

Posts: 34
Trades: 0
I have to access a columm with some BLOBs (with PDF content) in the database. I tried to use "Response.BinaryWrite" but it gives me the following error:

An unhandled data type was encountered.

Is there something that I have to declare first? Does anyone know how to read these BLOB data from the database and display them as pdf files?

Thanks in advance.
tcb.
tcb is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 10-18-2005, 03:23 PM
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,519
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
how about trying Google binarywrite pdf

The top result seems to fit.
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 10-19-2005, 10:44 AM
tcb
Experienced Talker

Posts: 34
Trades: 0
Hi Chris,

The top result is from a forum from which only members can see the result of the answers. But thanks anyway. And I didn't find the answer for my problem yet.

tcb
tcb is offline
Reply With Quote
View Public Profile
 
Old 10-19-2005, 01:02 PM
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,519
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
nope, you only need to sign up to see who got the points, and the accepted answer. Scroll down and you will see all the answers given.
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 10-20-2005, 06:35 AM
tcb
Experienced Talker

Posts: 34
Trades: 0
Thank you Chris, but I couldn't solve my problem yet. I found some solutions there and in other sites and I realized that many people use the following lines on their code:

Response.ContentType = "application/pdf"
Response.BinaryWrite objRs("BLOB_columm")

but what happens is that comes a box trying to open a file, but nothing actually appears. It says that the data I am trying to read may cause some damage to the computer. Do you have any idea of what's happening?

tcb.
tcb is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to How to access BLOBs from database
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.14982 seconds with 12 queries