Unix Technical Forum

File download works from Access but not from SQL Server

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) ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 08:13 PM
Roger Withnell
 
Posts: n/a
Default File download works from Access but not from SQL Server

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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 03:14 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com