| Author |
Topic |
|
karuna
Aged Yak Warrior
582 Posts |
 Posted - 2002-02-17 : 08:55:43
|
| I want to give my users to upload thier word documents.How can I store that in the sql server.How it would be stored.If the users retrieve it,will it be in the same format they uploaded or it would be a text file.How can I store it in the database with out the help of any component.KarunakaranDon't wait for things to happen,Make them to happen... |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-02-17 : 09:04:08
|
| if i were you , i would have saved only the file path rather then going in the complexity of storing it in the database and adding overheads about its maitenance . read the FAQ of this site on storing image, you shoud get some good idea.HTH--------------------------------------------------------------"Happiness is not something you experience, it's something you remember." |
 |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2002-02-17 : 09:21:20
|
| Yes Nazim.I store the document in the server in a physical directory too...The reason I want to have it in the DB is one more option.In case if any thing goes wrong...At least I will be having the documents in the DB Backup.....KarunakaranDon't wait for things to happen,Make them to happen... |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-17 : 09:54:48
|
| If you need to back up the files on disk, then copy them to another directory. Storing them in the database is far more difficult and much less flexible. |
|
|
|
Da_Retina
Posting Yak Master
109 Posts |
Posted - 2002-02-17 : 10:20:43
|
| Salute..I would vote on storing the path not the physical file!..Salute..------------------If I am to do it,I will, and NOW .. |
|
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2002-02-17 : 10:38:22
|
| Thank you guys...If some one can give me how to insert it into the table and to retrieve from the table it would be helpfull for me to know atleast how it works... KarunakaranDon't wait for things to happen,Make them to happen... |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-02-17 : 19:54:28
|
HiI think by now I think you should be getting the idea that pretty much everyone thinks it is a BAD IDEA.Most of my work is image and document storage and management systems, so I have been up against what you want to do. Trust me on this, store them in the filesystem. A filesystem is meant for storing files. A database is meant for storing data. Store you documents in the filesystem....Get my point yet  However, if you still insist. As Nazim suggested, it's in the F.A.Q. ( www.sqlteam.com/faq.asp ). Read the article about why you don't want to do it, then follow the links off to some KB articles about how to do it.Damian |
|
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2002-02-18 : 03:54:40
|
| Hi Guys,I think you all misunderstood my need or I was not clear on what I want.As of now I have the component ASPSMARTUPLOAD from ASPSMART,With the help of the component I store the documents in the server's HDD. As an additional storage I thought to store it on DB.Since all of you guys suggested not to do that,I dropped that Idea of doing that in the website.But still I like to give it a try in my local development enviornment.Thanks for the suggestion guys....I prefer to learn some of the lessons in the HARD WAY.So I wont do the same mistake again KarunakaranDon't wait for things to happen,Make them to happen... |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-02-18 : 15:10:49
|
Karuna,If you want to bang your head against the wall for fun, go right ahead. One place to start is looking up the commands READTEXT and WRITETEXT in BOL. Also lookup ntext or Unicode.Have fun  ----------------------------------------Doctor, it hurts when I do this... |
|
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2002-02-19 : 03:21:41
|
| Thank you Guys for all your suggestions and advice..Once I bang my head in the wall,I'll post my experience...KarunakaranDon't wait for things to happen,Make them to happen... |
|
|
|
|
Saving a word document in SQL