send word file to sql server,but a problem about show it
-
now i have a problem about MIME. a program ,condition as office2000+ in the client,as: <% response.Buffer = true; 'strConn = "Driver={SQL Server};Server=jiangjh;UID=sa;PWD=;database=cgdb" strConn = "Driver={SQL Server};Server=jiangjh;UID=sa;PWD=;database=cgdb" Set Conn=Server.CreateObject("ADODB.Connection") conn.CursorLocation = 3 Conn.Open(strConn) set rs=server.CreateObject ("adodb.recordset") sql="select * from testWordToHtml where id=5 order by id desc" rs.Open sql,conn,1,1 'if office2000,no problem,but office2003,it is not be showed,then alert download it ' Response.ContentType = "application/msword" response.BinaryWrite rs("content") rs.Close conn.Close set conn=nothing %> now,the data is right and got by sql server(field type is image .) where we get data to screen,IE alert download this word file.if office2000 is setup in the client pc,this problem is not appear.if office2003,this is again. why? look this 'Response.ContentType ="application/msword" ' ,is it right?i know it is supported in office200, is it supported in office2003??? if it is not supported,then what is the code ? You are the best!Me too!