VB 6.0 - How t save image(jpg) to sqlserver 2000 using VB6

Asked By c v on 14-Jun-06 12:02 AM
Hello, How could i save a jpg file into a table having an image datatype? I'm using VB6 ang SQLserver 2000. Please help me to do this. This is very helpful to most vb6 programmers. Thank you very much..
Asked By Shallu Gupta on 14-Jun-06 12:37 AM
Hi,
I would advise you to store the path of Image in Sql server not the image and load it in ur front end from the specified path. However, for storing images in DB see this link..
http://www.vbcity.com/forums/faq.asp?fid=8&cat;=Database&#TID123148
you can modify the connection from Ms Access to SQL Server

it works

Asked By Ricky Suicano on 14-Jun-06 02:49 AM
ur great men! keep 8 it up.

Thank you Shallu Gupta

Asked By c v on 06-Jul-06 12:21 AM
Hi Shallu Gupta. Thank you very much for this solution. Its a great help. Actually i use to store the path of the image in the table(Database) but i'l having a problem in PORTABILITY or else i'l have to maintain the path forever just to make it snychorize of what ever is saved. For the way i see it, the advantage is just i can have a light weight of data because it's just a string. Right? I do prefer to save the actual IMAGE unless the portability issue will be addressed in using path. Hope  there is
And now i already got of how to saved image(from you as source). I experienced a dificulty of how display the image in my report(Crystal Report 8.5). i hope you could still extend your best skill on me..
Thank you very.
How to show the image in crystal report 10 from SQL server Table
Taskheer Hussain replied to c v on 29-May-09 02:42 PM

 Dear charlie Valizado,



will you please send me the code that how u r storing the path of the image file and how u r calling this image in crystal.


Joseph replied to c v on 23-Feb-11 09:46 AM
How do I store image (jpg) file in SQL Server 2000 and to retrieve the image as picture in VB6