Jim Lawrence (AccessD)
accessd at shaw.ca
Fri Jun 18 20:20:16 CDT 2004
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