Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error saving Excel document in varbinary(max) field Expand / Collapse
Author
Message
Posted Tuesday, February 25, 2014 1:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 9:37 PM
Points: 1, Visits: 4
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
Post #1544797
Posted Tuesday, April 22, 2014 8:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 30, 2014 12:22 AM
Points: 1, Visits: 3
anoopk4u (2/25/2014)
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



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
Post #1564077
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse