高手啊！我想从数据库读取二进制视频文件但读出的文件是乱码或者是下载文件怎么办啊！
<!--#include file= "conn.asp "-->
<%
id=request( "id ")
set rs=server.createobject( "ADODB.recordset ")
sql= "select * from pic where id= " & id
rs.open sql,conn,1,1
Response.ContentType = "video/* "
Response.BinaryWrite rs( "big ")
%>
<p> <span style= "cursor:hand " onclick= "document.MediaPlayer1.filename= ' <%Response.BinaryWrite rs( "big ")%> ' "> <font color= "#CC3300 "> 播放 </font> </span> </p>
<object classid= "clsid:22D6F312-B0F6-11D0-94AB-0080C74C7E95 " id= "MediaPlayer1 " width= "452 " height= "352 ">
<param name= "AudioStream " value= "-1 " />
<param name= "AutoSize " value= "-1 " />
<param name= "AutoStart " value= "-1 " />
<param name= "AnimationAtStart " value= "-1 " />
<param name= "AllowScan " value= "-1 " />
<param name= "AllowChangeDisplaySize " value= "-1 " />
<param name= "AutoRewind " value= "0 " />
<param name= "Balance " value= "0 " />
<param name= "BaseURL " value />
<param name= "BufferingTime " value= "15 " />
<param name= "CaptioningID " value />
<param name= "ClickToPlay " value= "-1 " />
<param name= "CursorType " value= "0 " />
<param name= "CurrentPosition " value= "0 " />
<param name= "CurrentMarker " value= "0 " />

<param name= "DefaultFrame " value />
<param name= "DisplayBackColor " value= "0 " />
<param name= "DisplayForeColor " value= "16777215 " />
<param name= "DisplayMode " value= "0 " />
<param name= "DisplaySize " value= "0 " />
<param name= "Enabled " value= "-1 " />
<param name= "EnableContextMenu " value= "-1 " />
<!-是否用右键弹出菜单控制-->
<param name= "EnablePositionControls " value= "-1 " />
<param name= "EnableFullScreenControls " value= "-1 " />
<param name= "EnableTracker " value= "-1 " />
<!--是否允许拉动播放进度条到任意地方播放-->
<param name= "Filename " value= "Music/sayoldtime.mp3 " valuetype= "ref " />
<param name= "InvokeURLs " value= "-1 " />
<param name= "Language " value= "-1 " />
<param name= "Mute " value= "0 " />
<!--是否静音-->
<param name= "PlayCount " value= "10 " />
<!--重复播放次数,0为始终重复-->
<param name= "PreviewMode " value= "-1 " />
<param name= "Rate " value= "1 " />

<!--播放速度1.0-2.0倍的速度播放-->
<param name= "SAMILang " value />
<param name= "SAMIStyle " value />
<param name= "SAMIFileName " value />
<!--是否显示字幕,为一块黑色,下面会有一大块黑色,一般不显示-->
<param name= "ShowControls " value= "-1 " />
<!--是否显示控制,比如播放,停止,暂停-->
<param name= "ShowAudioControls " value= "-1 " />
<!--是否显示音量控制-->
<param name= "ShowDisplay " value= "0 " />
<!--显示节目信息,比如版权等-->
<param name= "ShowGotoBar " value= "0 " />
<!--一条框,在下面,有往下箭头-->
<param name= "ShowPositionControls " value= "-1 " />
<!--是否显示往前往后及列表,如果显示一般也都是灰色不可控制-->
<param name= "ShowStatusBar " value= "-1 " />
<!--当前播放信息,显示是否正在播放,及总播放时间和当前播放到的时间-->
<param name= "ShowTracker " value= "-1 " />
<!--是否显示当前播放跟踪条,即当前的播放进度条-->
<param name= "TransparentAtStart " value= "-1 " />
<param name= "VideoBorderWidth " value= "0 " />
<!--显示部的宽部,如果小于视频宽,则最小为视频宽,或者加大到指定值,并自动加大高度.此改变只改变四周的黑框大小,不改变视频大小-->

<param name= "VideoBorderColor " value= "0 " />
<!--显示黑色框的颜色, 为RGB值,比如ffff00为黄色-->
<param name= "VideoBorder3D " value= "0 " />
<param name= "Volume " value= "0 " />
<!--音量大小,负值表示是当前音量的减值,值自动会取绝对值,最大为0,最小为-9640,最大0-->
<param name= "WindowlessVideo " value= "0 " />
<!--如果是0可以允许全屏,否则只能在窗口中查看-->
</object>

[解决办法]
<%
id=request( "id ")
%>
<p> <span style= "cursor:hand " onclick= "document.MediaPlayer1.filename= ' <%Response.BinaryWrite rs( "big ")%> ' "> <font color= "#CC3300 "> 播放 </font> </span> </p>
<object classid= "clsid:22D6F312-B0F6-11D0-94AB-0080C74C7E95 " id= "MediaPlayer1 " width= "452 " height= "352 ">
<param name= "AudioStream " value= "-1 " />
<param name= "AutoSize " value= "-1 " />
<param name= "AutoStart " value= "-1 " />
<param name= "AnimationAtStart " value= "-1 " />
<param name= "AllowScan " value= "-1 " />
<param name= "AllowChangeDisplaySize " value= "-1 " />
<param name= "AutoRewind " value= "0 " />
<param name= "Balance " value= "0 " />
<param name= "BaseURL " value />
<param name= "BufferingTime " value= "15 " />
<param name= "CaptioningID " value />
<param name= "ClickToPlay " value= "-1 " />
<param name= "CursorType " value= "0 " />
<param name= "CurrentPosition " value= "0 " />
<param name= "CurrentMarker " value= "0 " />
<param name= "DefaultFrame " value />
<param name= "DisplayBackColor " value= "0 " />
<param name= "DisplayForeColor " value= "16777215 " />
<param name= "DisplayMode " value= "0 " />
<param name= "DisplaySize " value= "0 " />
<param name= "Enabled " value= "-1 " />
<param name= "EnableContextMenu " value= "-1 " />
<!-是否用右键弹出菜单控制-->

<param name= "EnablePositionControls " value= "-1 " />
<param name= "EnableFullScreenControls " value= "-1 " />
<param name= "EnableTracker " value= "-1 " />
<!--是否允许拉动播放进度条到任意地方播放-->
<param name= "Filename " value= "show.asp?id= <%=id%> " valuetype= "ref " />
<param name= "InvokeURLs " value= "-1 " />
<param name= "Language " value= "-1 " />
<param name= "Mute " value= "0 " />
<!--是否静音-->
<param name= "PlayCount " value= "10 " />
<!--重复播放次数,0为始终重复-->
<param name= "PreviewMode " value= "-1 " />
<param name= "Rate " value= "1 " />
<!--播放速度1.0-2.0倍的速度播放-->
<param name= "SAMILang " value />
<param name= "SAMIStyle " value />
<param name= "SAMIFileName " value />
<!--是否显示字幕,为一块黑色,下面会有一大块黑色,一般不显示-->
<param name= "ShowControls " value= "-1 " />
<!--是否显示控制,比如播放,停止,暂停-->
<param name= "ShowAudioControls " value= "-1 " />
<!--是否显示音量控制-->
<param name= "ShowDisplay " value= "0 " />
<!--显示节目信息,比如版权等-->
<param name= "ShowGotoBar " value= "0 " />
<!--一条框,在下面,有往下箭头-->
<param name= "ShowPositionControls " value= "-1 " />
<!--是否显示往前往后及列表,如果显示一般也都是灰色不可控制-->
<param name= "ShowStatusBar " value= "-1 " />
<!--当前播放信息,显示是否正在播放,及总播放时间和当前播放到的时间-->
<param name= "ShowTracker " value= "-1 " />
<!--是否显示当前播放跟踪条,即当前的播放进度条-->
<param name= "TransparentAtStart " value= "-1 " />
<param name= "VideoBorderWidth " value= "0 " />
<!--显示部的宽部,如果小于视频宽,则最小为视频宽,或者加大到指定值,并自动加大高度.此改变只改变四周的黑框大小,不改变视频大小-->
<param name= "VideoBorderColor " value= "0 " />
<!--显示黑色框的颜色, 为RGB值,比如ffff00为黄色-->
<param name= "VideoBorder3D " value= "0 " />
<param name= "Volume " value= "0 " />
<!--音量大小,负值表示是当前音量的减值,值自动会取绝对值,最大为0,最小为-9640,最大0-->
<param name= "WindowlessVideo " value= "0 " />
<!--如果是0可以允许全屏,否则只能在窗口中查看-->
</object>


show.asp:
<!--#include file= "conn.asp "-->
<%
id=request( "id ")
set rs=server.createobject( "ADODB.recordset ")
sql= "select * from pic where id= " & id
rs.open sql,conn,1,1
Response.ContentType = "video/* "
Response.BinaryWrite rs( "big ")
%>