Storing a Graphic in an SQL Database 1

[JpPhysics]

I would like to know if it is possible, and if so how to, store a graphic like a .wmf or .jpg file in an sql database.

Thanks for your help.

 

[JayKusch]

Yes you can store Images im the Image field or use BLOBs. Binary Large OBjects.

For Blobs, take a look at this link:

http://www.microsoft.com/technet/tr...rodtechnol/sql/reskit/sql2000/part3/c1161.asp

For Image Fields you might want to read up on them in BOL,
Books On-Line

 

[JpPhysics]

Thanks for the direction.

Man, looks like I've got quite a bit of work ahead of me.

 

[JpPhysics]

Ok, I have read the article, but I don't understand about the size of the field. Am I limited by SQL Sever on the size of the the Image or what?

Also, how, in VB can I break up an Image file into smaller chunks to save into the database if that is what's required?

 

[PFR]

if You define the image column as image the data size is practically unlimited.
dont know much abt VB - in C using ODBC data up to ~400kb can be bound directly to the table column, larger data must be split and put in parts.
PFR

 

[Guest_imported]

You should really be using ADODB.Stream which is much easier then GetChunk etc.

This site (amongst many others) shows an example:

http://www.betav.com/Files/Content/Whitepapers/Using the ADO Stream Object to Manage BLOBs.htm

Good Luck

 

[JpPhysics]

Thanks again for your help. This has been most educational. I think that I have it now!