Problem retrieving BLOB data from Informix database using ADO.NET
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 unloading the blob from the database directly and was able to view the same without any problem. However when retrieved through ADO.NET , the files are getting corrupted.
Any ideas, please let me know
Thanks
Venkatesh