Hi
need help.
I have a sql server database storing files such as MS Word documents as binary data.
I would like to now go through the database and get the binary data using vb.net and convert the data in to the approriate file (e.g word document) and save it on the server
any advise? or scripts?

a


A

I have had some success (but look forward to any further advise suggestions.):

        Dim drGetBinaryExampleFile As SqlDataReader
        drGetBinaryExampleFile = ExecuteReader(...)
        If drGetBinaryExampleFile.Read() Then
            Try
                Dim fs As New FileStream("c:\\IntranetDocument\file.doc", FileMode.Create, FileAccess.Write)
                Dim stw As New BinaryWriter(fs)
                stw.Write(drGetBinaryExampleFile.Item("binFile"))

                stw.Close()
                fs.Close()
                Response.Write("Succes in writing a file")
            Catch ex As Exception
                Response.Write("<li>error")
                Response.Write(ex.ToString)
            End Try


A