Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB How-To
|
VB How-To Ask your "How do I do this with VB?" questions in this forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 1st, 2005, 02:27 AM
Registered User
 
Join Date: Jun 2005
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to vaneza
Default how to save images in sql2000 using vb6


Im having a problem on how to save images in sql2000. Im currently using vb6

 
Old August 1st, 2005, 02:47 AM
Friend of Wrox
 
Join Date: Dec 2004
Posts: 221
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello

Check this link
http://www.motobit.com/tips/detpg_re...ql-image-file/

Hope this helps

With Regards,
Raghavendra Mudugal
 
Old August 1st, 2005, 03:01 AM
Friend of Wrox
 
Join Date: Dec 2004
Posts: 221
Thanks: 0
Thanked 0 Times in 0 Posts
Default

and this link too...

http://www.sadikhov.com/forum/Insert...%3B_25178.html

it is c# language, but look for the way how he gets the bytes on the image
and insert it to the IMAGE (datatype) column and do the same in VB
you can use OPEN method in BINARY ACCESS READ and get the bytes
and insert them into that column OR use FSO(file system objects)

Hope this helps

With Regards,
Raghavendra Mudugal
 
Old August 1st, 2005, 11:24 PM
Registered User
 
Join Date: Jun 2005
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to vaneza
Default

thanks for the reply... Raghavendra.... but is there any simpler way to do it... im just new here and im having a roller coaster mind in thinking of the solution....



 
Old August 1st, 2005, 11:41 PM
Friend of Wrox
 
Join Date: Dec 2004
Posts: 221
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello Vaneza

Beacuse handling images just by inserting into the database table with
SQL query is very very difficult if you compare the way i provided.
Is the only way all people do.

If i come accross any improved or simple way, will tell you. This shows
my limitations on this part.

If you come accross any new way, please let me know.

With Regards,
Raghavendra Mudugal
 
Old August 17th, 2005, 03:08 AM
Registered User
 
Join Date: Aug 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to orgk81
Default

If you are using ADO, try using recordset object's GetChunk and AppendChunk. For More information, read MSDN Help Library.
Use Keywords "GetChunk, AppendChunk" for example.

Regards,
Ganesh Kumar O.R.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Load Images from and Save Images to a Database cyndie VB.NET 2 August 17th, 2008 06:42 AM
save images in size .75 X .75 infotech VB How-To 2 May 11th, 2007 05:54 PM
Save images in Sql Db itHighway SQL Server 2000 5 October 18th, 2006 10:39 AM
database concurreny problem with vb6 and sql2000 shamimbd17 SQL Server 2000 0 August 21st, 2006 06:03 AM
Save Images in Sql Db itHighway Classic ASP Basics 7 August 10th, 2005 01:07 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.