This is a discussion on File download works from Access but not from SQL Server within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> My file, a Word .doc, will download from Access (datatype OLE Object) but not from SQL Server (datatype Image) ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| My file, a Word .doc, will download from Access (datatype OLE Object) but not from SQL Server (datatype Image) using exactly the same code except to change the DSN of course. My code uses Response.ContentType application/octet-stream (is this correct for SQL Server Image datatype?) followed by Response.AddHeader Content Disposition and Content- Length to get the file name and size and then Response.BinaryWrite. Using the SQL Server database fails when I click OK to save the file to the browser's disc. IE says it can't find the internet site. Using Access, the file downloads successfully to the client browser. Please advise. |