Store document in SQL Server (but not on file)

[jonas.berling]

Hi,

There are several postings on how to upload a Word document to an SQL
Server 2000 and we have implemented that already. But my users would
prefer to never have to store the document to file, just click some
custom made button like "Store in DB", fill in some additional (meta-)
data and more or less post it to the DB. I could easily put ADO code
in our templates, but how do I get a handle on the document that I can
use in ADO calls? I can imagine something like
"ActiveDocument.Binary". Is this possible? If not, other ideas?

Regards,
Jonas

 

[Peter Jamieson]

I don't think there's a way to avoid saving to something that looks either
like a Windows file system folder or a (say) an ftp or http URL. But there's
no reason why the user has to do that save explicitly. You could even
consider doing the save, then have some server-based process do all the rest
of the work so the user gets back to Word faster, if performance is the
issue. I don't know if there's a way to save to a "storage" that you could
pick up from ADO, sorry.