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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-19 : 12:23:15
|
| Srinivas writes "I'm able to store images into the database (sqlserver7.0 )in vb application by usingj ADO's. But i'm unable to retrieve the storedimage from the database.Pl help meSrinivas" |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-06-19 : 12:38:32
|
| Ahhhh, run from the evil images hiding in your Database... Or something like that.I'd recommend against storing images in your DB. Store the image on your servers hard drive and simply hold the file name and the directory in your database-----------------------Take my advice, I dare ya |
 |
|
|
jackstow
Posting Yak Master
160 Posts |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-06-20 : 04:47:00
|
| Check FAQ on this site .-------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson |
|
|
|
bouno
Starting Member
23 Posts |
Posted - 2002-06-24 : 14:54:30
|
| Hi all,can someone explain how to create an image for a mssql database server?TIA,bouno |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-24 : 15:23:55
|
| You don't actually create the image in SQL Server, you load the binary data of the image from a JPEG or GIF file into SQL Server. This is usually accomplished by using ADO Stream objects, which were designed primarily for this purpose. |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-06-24 : 15:37:28
|
quote:
can someone explain how to create an image for a mssql database server?
You are not, by any chance, confusing an image (bitmap, jpeg, tiff) with a disk image that would be created by software like Norton Ghost?<O> |
|
|
|
|
|
|
Images in DB