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.
| Author |
Topic |
|
pawan
Starting Member
7 Posts |
 Posted - 2004-09-01 : 02:52:39
|
| sir, we r developing an application using sqlserver 2000 and VB for NBFC , sir ve want to store images of customer in database . is there is any way to store images in database (expected customers are 10000). |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-09-01 : 04:51:45
|
| You can - SQL Server uses binary fields that can allow any sort of data to be stored - images included.However, it is not generally recommended to store images in the database. It is better to store the images in a directory somewhere and then save the path in a varchar field. |
 |
|
|
pawan
Starting Member
7 Posts |
Posted - 2004-09-02 : 09:18:19
|
| thanks but ADO does not support long binary data so how should we show images stored in database |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-09-02 : 09:26:08
|
| You missed the key point.Don't do this, store the images on a filesystem and store the path to the files in the database. This will save you problems in the future.-------Moo. :) |
|
|
|
DustinMichaels
Constraint Violating Yak Guru
464 Posts |
Posted - 2004-09-02 : 09:26:11
|
| Try storing it in a Image or Text column. But the best solution would to store the path to the file that timmy suggested. |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-09-02 : 19:26:57
|
quote:
thanks but ADO does not support long binary data so how should we show images stored in database
It does - there are some methods (ReadChunk is one) that lets you read binary data from a recordset. There is also one for writing binary data, but I can't recall the name. Read up on ADO if you insist on storing images in a database. |
|
|
|
|
|
|
store images in database with ADO (VB)