how to read and store a large file from SQL Server 2000?

hi..

I want to store a RMVB file to SQL SERVER 2000 ,and read from it,iwant to play the RMVB file in web,the size of the RMVB file is more than 300MB less 1G.the SQL FieldImage can include it.

Now My Quesstion is How can i Store and Read the RMVB file from SQL Server2000?

I usedSqlInsertCommand.ExecuteNoquery() in my program,but it Too slow,ao make a unknown error.

Thank you for your help.

I would seriously recomend not putting stuff like this into your db. Store a hard link to the file in your db, and put the file in the file system where it belongs. Binary data in your db of that size is only going to slow down every db operation you hope to accomplish.

|||And if you don't even execute the database functions it is fast enough and you don't get any errors?|||

thanks

I try it as you say,the code is:<embed src="http://pics.10026.com/?src=a.rmvb" height=200 width=200>but when it run,there are error Message:"the link of http://x.x.x.x/a.rmvb" is timeout or wrong" but the a.rmvb is realy in there and the link time is less then 1 second.

where is wong?thanks for your help!

|||

Please post your entire set of code that inserts this item into a database so we can troubleshoot it.

|||

hi..

the code is that:

WebForm1 -->WebForm1 -->WebForm1 --> body MS_POSITIONING="GridLayout"

form id="Form1" method="post" runat="server"

embed src="http://pics.10026.com/?src=Request["path"]" width=200 height=200>/embed

/form>

/body>

the path=a.rmvb

and when it run in localhost it is all right,but when it is wrong in server(the server not install realplay software)

where is wrong ?

thanks for your help!

|||

hi..

when i install realply in the server,it is all ok!