Reading BLOB data from Informix database using ADO.NET

Nov 4 2004 9:46 PM
Guys, I am trying to read BLOB data from Informix database using ADO.NET. I am able to upload any type of file (.xls, .doc, .pdf) into the database as a BLOB. However when retrieving, i am encountering a problem. I am using a data reader to retrieve the blob data, writing to a temporary file and rendering it based on content type. I am able to successfully upload and retrieve Excel documents. But the .doc & .pdf files are getting corrupted after retrieving from the database. The file sizes of the original document and retrieved document are same. I tried unload the blob from the database directly and was able to view the same. However when retrieved through ADO.NET , the files are getting corrupted. Any ideas, please let me know Thanks Venkatesh