Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 storing documents in sql

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-14 : 22:04:35
Ale writes "How can i store and read Word document in sql server 2000?
I know it is possible with image field but i don't know how.
I use asp pages. Help me! Thank You"

Nazim
A custom title

1408 Posts

Posted - 2002-04-15 : 00:21:02
Its not recommended that you store image or word documents in your database. it tells on system performance.
check this site's FAQ on how to store images. you can follow similar kinda logic to work with word documents.

--------------------------------------------------------------
Go to Top of Page

tribune
Posting Yak Master

105 Posts

Posted - 2002-04-15 : 02:11:54
yep

use a varchar field storing the full path to the document, then use the asp filesystem object and textstream objects to read the file

Go to Top of Page
   

- Advertisement -