June 28, 2002 at 4:33 pm
Has anyone stored Word documents in SQL Server.
I have to either store a word document in SQL Server, or the contents of the word document in sql server, but always use word to edit the document.
So far I have found a way of storing / retrieving the word document in SQL server image field. I have used VB, ADO recordset and ADO StreamObject, but is ther a better way.....
Please help!
abdul
abdul
June 28, 2002 at 4:50 pm
There are a few discussions on this in this forum. Search for image storage and see.
My vote, store the doc in the filesystem and a reference in SQL, but others disagree.
Steve Jones
June 28, 2002 at 4:51 pm
that was a quick reply!
abdul
abdul
July 1, 2002 at 1:57 am
I've done it using an ADO Stream object. See Wrox Press ADO 2.6 Programmer's Reference.
Once you have done it for one sort of file then you can do it for any.
I did it as an academic excercise to see if I could build the bare bones of a document management system, where it is very important to be able to revert to previous instances of documents and also to see the history of those documents.
July 1, 2002 at 1:01 pm
Thanks david,
I can read / write using the stream object. However I am dealing with 3 tier architecture the problem is I don't have ADO at the front end.. any resolutions for that???
abdul
abdul
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply