Hello,

We are using ASP.NET and SQL Server 2005 for storing doc/jpeg/gif images in database.

All thing works fine in IE and FF. But when try to open the doc file on safari browser on any platform it ask as to save the .aspx file.

How can I open the doc file on safari browser??

Thanks,
Deepesh Verma

Are you using the correct MIME types for the files. i.e. image/jpeg for JPEGs image/gif for GIFs and application/msword for DOC files in your handler?

TheDarkKnight:

Are you using the correct MIME types for the files. i.e. image/jpeg for JPEGs image/gif for GIFs and application/msword for DOC files in your handler?

 Yes I am using same MIME type.

Try changing the mime type of the doc to application/octet-stream. As it is very much likely that Safari may not recognize .doc as a MIME type. It's better to set the MIME header as application/msword in case of IE and set it to application/octet-stream in Firefox & Safari when the file is to be sent to the browser by the handler.

Not working, For you reference the code I am using is below, this might help you to find the problem.

Thanks in advance.

  protected void LinkButton1_Click(object sender, EventArgs e)
    {

        string str = "SELECT [ID] ,[FileName] ,[Extension] ,[Content] FROM [TestDB].[dbo].[TestTable] where ID = (Select Max(ID) from TestTable ) ";
        using (SqlConnection cnn = new SqlConnection("Data Source=earth;Initial Catalog=TestDB;Persist Security Info=True;User ID=sa;Password=sa"))
        {

            cnn.Open();
            SqlCommand cmd = new SqlCommand(str, cnn);
            cmd.CommandType = CommandType.Text;

            SqlDataReader dr = cmd.ExecuteReader();
            if (dr.HasRows)
            {
                dr.Read();
                string strExtenstion = dr[2].ToString();
                byte[] bytFile = (byte[])dr[3];

                Response.Clear();
                Response.Buffer = true;

                if (strExtenstion == ".doc" || strExtenstion == ".docx")
                {
                   // Response.ContentType = "application/msword";
                    Response.ContentType = "application/octet-stream";

                    //Response.AddHeader("Content-Disposition", "inline; filename=report.aspx.doc");
                    Response.AddHeader("content-disposition", "inline;filename=tr.doc");
                }
                else if (strExtenstion == ".xls" || strExtenstion == ".xlsx")
                {
                    Response.ContentType = "application/vnd.ms-excel";
                    Response.AddHeader("content-disposition", "attachment;filename=Tr.xls");
                }
                else if (strExtenstion == ".pdf")
                {
                    Response.ContentType = "application/pdf";

                    Response.AddHeader("content-disposition", "attachment;filename=Tr.pdf");
                }

                Response.Charset = "";
                Response.Cache.SetCacheability(HttpCacheability.NoCache);

                // If you write,
                // Response.Write(bytFile1);
                // then you will get only 13 byte in bytFile.
                Response.BinaryWrite(bytFile);

                Response.End();
            }
        }
      
    }

I implemented your logic on a simple page and tested on Safari 3.4 beta on Windows. And it works here ... Are you facing problems with Safari on Mac?

 Thanks a lot for the confirmation,

But we are facing problem on Safari 3.0.3 on windows XP and we are using a third party tool www.browsercam.com for testing it on MAC, and there also is saving the file as .aspx.
As it is working at your end, I think it may be some plug-in issues or some thing else.

What do you suggest??

Thanks one again 

I can confirm if there is indeed a problem with Safari on Mac in the next 24 hours. I do not have access to a Mac @ home.

Thanks, no issues. 

TheDarkKnight:

I can confirm if there is indeed a problem with Safari on Mac in the next 24 hours. I do not have access to a Mac @ home.

Hello,

Did you get the time to check the code with safari on Mac. Waiting for reply.

Thanks, 

Yes, I've tested the code right now on a mac with OS X 10.4. It works without any problems.

 Thanks a lot!!!