question

I am using following line in my stored procedure to create a pdf file from blob field (data type of image). EXEC @ObjectReturn= sp_OACreate 'ADODB.Stream', @ObjectToken OUTPUT EXEC @ObjectReturn=sp_OASetProperty @ObjectToken, 'Type', 1 EXEC @ObjectReturn=sp_OAMethod @ObjectToken, 'Open' EXEC @ObjectReturn=sp_OAMethod @ObjectToken, 'Write', NULL, @BlobToDisk IF @ObjectReturn<>0 BEGIN EXEC sp_OAGetErrorInfo @ObjectReturn, @src OUT, @desc OUT raiserror('Error Creating SaveToFile Component 0x%x, %s, %s',16,1, @hr, @src, @desc) RETURN END EXEC @ObjectReturn=sp_OAMethod @ObjectToken, 'SaveToFile', NULL, @InFileName, 2 EXEC sp_OAMethod @ObjectToken, 'Close' EXEC sp_OADestroy @ObjectToken InFileName is set to a valid folder location with file extension of .pdf example : c:/PDFDocs/test.pdf The stored proc executes fine and pdf file gets created. However, when I try to open this pdf file I get a message in reader saying file is damaged. The same stored proc works absolutely fine on sql server 2012 r2. I am facing this problem only on 2008 r2. Please help!