Error saving Excel document in varbinary(max) field

• anoopk4u

  Grasshopper

  Points: 11

  More actions

  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

• bonniereed346

  Grasshopper

  Points: 11

  More actions

  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