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