I am back to this problem
Since this original thread, I have purchased ASPDB pro and have used it in several projects for our intranet and internet. I still think it is a fantastic product. I still need help with getting PDF files to display. The are currently saved as blob data in a SQL2000 database. Here is the code I am using:
X.dbBLOB = "Attachment01,application/pdf,Field Worksheet,1,,"
The message I get back from the browser is:
File does not begin with '%PDF-'
If I right click on the linked blob, I can save the file to my local hard drive. I can not open with acrobat, but when I open the file with word pad, I see a bunch of junk characters before %PDF-. I am assuming that this is the offset. Is that correct? and if so, how do I calculate the offset value? do I just count all the characters and spaces? Or is this info that you would have? Any help would be appreciated. I can't seem to copy and paste the header/offset data into this message, but would email it to you on request. Thanks in advance.
This is getting frustrating
I played around with the offset value and the problem seems to be with the data being output from SQL. at an offset of 1640 I get the File does not begin with '%PDF-' error. when the offset is increased to 1641, i get an error message of 'the file is damaged and cannot be repaired. both messages are coming from Acrobat. Why does MS have to make everything so damn difficult. the file the I right click and save from the code generated by ASPDB is only 22K, but when I use Access to retrieve and save the same blod field, the size is 379K. So it is like the retrieval process is 'wrong' using ASPDB pro. ??? any comments. I will do a test by saving a JPG file and will post comments shortly.
Doug