[dba-SQLServer] Getting pictures into a blob in SQL Server

jwcolby jwcolby at colbyconsulting.com
Thu Jun 17 15:56:28 CDT 2004


Unfortunately the program the gentleman purchased embeds them in the db.  He
contacted them and they said they would not change that so...

John W. Colby 
www.ColbyConsulting.com

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim
Lawrence (AccessD)
Sent: Thursday, June 17, 2004 11:32 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] Getting pictures into a blob in SQL Server


Hi John:

Access or SQL (Oracle for that matter) bloat and display (extract) too
slowly. The fastest method that handles imbedded graphic files is using ADO
stream method. (If you are interested I will post the code.)

The only really good method, that avoids bloat and is by far the fastest, is
to store the graphic file externally and just uses the tables to track the
file locations.

HTH
Jim


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of jwcolby
Sent: Thursday, June 17, 2004 5:56 AM
To: SQLServer; 'Access Developers discussion and problem solving'
Subject: [dba-SQLServer] Getting pictures into a blob in SQL Server


I got a call from someone yesterday needing to get 25000 pictures into a
blob field in SQL Server.  The program he is attempting to use apparently
stores the pictures it uses in such a field.  These pictures are currently
stored as GIFs (I believe) on the hard drive.

I can write a program to cycle through a dir on the disk, but would I just
read the text into a string and dump it into the field, save and move on?
Has anyone ever done this?

I included AccessD in this request as I am guessing I'll just do it through
VBA in AccessD.

John W. Colby
www.ColbyConsulting.com


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com







More information about the dba-SQLServer mailing list