Very Computer

I am working on a database that contains some records that reference a
picture.  As things stand right now, the pictures are stored in a directory
somewhere on the server.  The DB records are pulled by some ASP code, and
the picture is displayed across the web.  I've noticed that SQL has an image
datatype, and I was wondering what would be the advantages to storing an
image in the DB as opposed to separately as a file, as well as the steps
need to store and retrieve the image across the web.  Thanks.

Xin Li

If you ever have the need to take copies of your database or need to
replicate it then you will be assured that the images will come with the
database and not need to worry about moving or copying a second data source.

Even if you do move the images separately within their file directory you
will have to make certain that any pointers to these images that you hold
within the database are updated if you change the actual location.

If you are going to access externally held images across the web then you
need to make certain that the physical files are on the correct side of any
fire walls to ensure that access will be allowed.  Storing the images within
the database gives the advantage of using the database level security.

Quote:> Hi,

> I am working on a database that contains some records that reference a
> picture.  As things stand right now, the pictures are stored in a
directory
> somewhere on the server.  The DB records are pulled by some ASP code, and
> the picture is displayed across the web.  I've noticed that SQL has an
image
> datatype, and I was wondering what would be the advantages to storing an
> image in the DB as opposed to separately as a file, as well as the steps
> need to store and retrieve the image across the web.  Thanks.

> Xin Li

Quote:> Hi,

> I am working on a database that contains some records that reference a
> picture.  As things stand right now, the pictures are stored in a
directory
> somewhere on the server.  The DB records are pulled by some ASP code, and
> the picture is displayed across the web.  I've noticed that SQL has an
image
> datatype, and I was wondering what would be the advantages to storing an
> image in the DB as opposed to separately as a file, as well as the steps
> need to store and retrieve the image across the web.  Thanks.

> Xin Li

regards
Greg O

Quote:> Hi,

> I am working on a database that contains some records that reference a
> picture.  As things stand right now, the pictures are stored in a
directory
> somewhere on the server.  The DB records are pulled by some ASP code, and
> the picture is displayed across the web.  I've noticed that SQL has an
image
> datatype, and I was wondering what would be the advantages to storing an
> image in the DB as opposed to separately as a file, as well as the steps
> need to store and retrieve the image across the web.  Thanks.

> Xin Li

When storing images on SQL Server in will store them as binary data like
this:

0x151C2F00020000000D000E0014002100...<more HEX
numbers>...FFFF9BFFFFFFFFFFFFFFFFE000000000000

Which doesn't look to pretty on a web page. You would have to use some type
of picture control on your page to render the binary data back into an
image.

As opposed to just doing an <IMG src="<urlpath or relative
path>/<imagename>.jpg">

--
Darren Brinksneader MCDBA, MCSE+I, CNE, CCA, MCT, CTT

Dim objUpload, lngLoop
FilePath="C:\INETPUB\WWWROOT\TEST\UPLOAD\"
If Request.TotalBytes > 0 Then
 Set objUpload = New Upload
 'For lngLoop = 0 to objUpload.Files.Count - 1
    'If accessing this page annonymously,
    'the internet guest account must have
    'write permission to the path below.
    objUpload.Files.Item(0).Save FilePath
 'Next
'-=--=-=--=-=-=-=-=- Insert image into Database
Dim dbImage
Dim rsImage
Dim mStream
strConnect="Provider=SQLOLEDB.1;Persist Security Info=False;User
ID=sa;password=;Initial Catalog=Test;Data Source=Knight"
set dbImage = server.createobject("adodb.connection")
set rsImage = server.CreateObject("adodb.recordset")
set mStream = server.CreateObject("adodb.stream")
dbImage.open(strConnect)
sqlstr="Select * from sketchinfos where intMasterAcctID=2"
rsImage.open sqlstr,dbImage,adOpenKeyset,adLockOptimistic
mStream.Type=adTypeBinary
mStream.Open
FileName=objUpload.Files.Item(0).FileName
mStream.LoadFromFile FilePath & FileName
rsImage.Fields("imgSketchJPG").Value=mStream.Read
rsImage.Update
rsImage.Close
dbImage.Close

Check out some ASP sites.  Mostly the biggest problem is that you need to
use a multi-part binary form to upload the information to where the database
can see it in the first place.

The other way you can get images into the database is via. the TEXTCOPY
utility.

Regards,

Christopher

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----==  Over 80,000 Newsgroups - 16 Different Servers! =-----