SQL server and saving .docs as binary

<i><b>Originally posted by : wayne creed (rayox@hotmail.com)</b></i><br />Is it feasible to save word .docs to sql server as binary objects, and do you need a third party software such as Persits upload to make this happen?<br />

<i><b>Originally posted by : Steve (stevebryant@bigfoot.com)</b></i><br /><br />Wayne, from what I understand you have to serialize the data first.<br /><br />Dim obj as object<br />Dim bf As new BinaryFormatter<br />Dim memStream As new MemoryStream<br />Dim ObjState As Byte()<br /><br />bf.serialize(memStream,obj)<br />ObjState = memStream.toarray<br /><br />write ObjState into an Image datatype using a stored proc, and the ExecuteNonQuery function on an SQLCommand.<br /><br />Getting the data back should just be the reverse, but I'm having trouble converting the initial object variable returned back into a byte array.<br /><br />If you get any further with this could you let me know<br /><br />Rgds<br /><br />Steve<br /><br />------------<br />wayne creed at 12/4/2000 8:13:28 AM<br /><br />Is it feasible to save word .docs to sql server as binary objects, and do you need a third party software such as Persits upload to make this happen?<br />