Post reply

Error saving Excel document in varbinary(max) field

  • February 25, 2014 at 1:49 am

    #288641

    Hello,

    We have a web site in asp.net where users can upload and save various documents.

    These are being stored in an SQL Server varbinary(max) field.

    I have issue where the insert fails for Excel spreadsheets but works for other document types including pdf, Word, zip and text files etc.

    I have Exception handling in my stored proc but I get no exception in Catch block.

    This works perfectly on Dev/Test box and happens only on production only for Excel files.

    Appreciate your valuable suggestions.

    Thanks,

    Anoop

  • April 22, 2014 at 8:55 pm

    #1707942

    anoopk4u (2/25/2014)

    Hello,

    We have a web site in asp.net where users can upload and save various documents[/url].

    These are being stored in an SQL Server varbinary(max) field.

    I have issue where the insert fails for Excel spreadsheets[/url] but works for other document types including pdf, Word, zip and text files etc.

    I have Exception handling in my stored proc but I get no exception in Catch block.

    This works perfectly on Dev/Test box and happens only on production only for Excel files.

    Appreciate your valuable suggestions.

    Thanks,

    Anoop

    Do not sure whether following post can help you a little. 🙂

    http://stackoverflow.com/questions/11176066/how-do-i-insert-retrieve-excel-files-to-varbinarymax-column-in-sql-server-2008

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply