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

MartyConnelly martyconnelly at shaw.ca
Sat Jun 19 16:53:29 CDT 2004


Here is a complete VB project that puts pictures into Access OLE Fields 
(non-embeded), heck you could put xml files in here, using get chunk 
methods.
It would be same to SQL Blob fields.
Store then Retrieve a File from a Jet Database Field - October 2000
http://www.buygold.net/tips/

Jim Lawrence (AccessD) wrote:

>Hi John:
>
>The application I was using, with the previously mentioned method of
>handling pictures was a worker registration and investigation system, for
>the government. The security handling was considered sufficient but there
>was no external access and the pictures without detail mean nothing.
>
>If you need any code snippets on a specific subject just ask.
>
>HTH
>Jim
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of jwcolby
>Sent: Friday, June 18, 2004 5:05 PM
>To: dba-sqlserver at databaseadvisors.com
>Subject: RE: [dba-SQLServer] Getting pictures into a blob in SQL Server
>
>
>This is going into SQL Server.  And I'm not sure what kind of program except
>it's something security related.  Pictures of people I am guessing.
>
>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: Friday, June 18, 2004 1:16 AM
>To: dba-sqlserver at databaseadvisors.com
>Subject: RE: [dba-SQLServer] Getting pictures into a blob in SQL Server
>
>
>Hi John:
>
>What type of program is it anyway? Once the graphics have been embedded they
>can be difficult to extact again. Depending on the embedding method, a
>Access DB can be completely swamped before you can say over-the-2-GB-limit.
>I had a corrupted MDB that had to have the embedded graphics files released
>and the patient made a complete recovery. It was not a difficult procedure
>but the extraction program ran for almost sixteen hours.
>
>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 1:56 PM
>To: dba-sqlserver at databaseadvisors.com
>Subject: RE: [dba-SQLServer] Getting pictures into a blob in SQL Server
>
>
>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
>
>
>
>
>_______________________________________________
>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
>
>
>
>
>_______________________________________________
>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
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the dba-SQLServer mailing list