Solved

Upload Image File to SQL

Posted on 2007-03-29
7
165 Views
Last Modified: 2010-04-30
I am wanting to create a visual basic 6 application to upload an image stored on my hard drive to a SQL database.  I have an image field that I am using to store the binary data.  Thanks in advance for the help!
0
Comment
Question by:jayh99
  • 4
7 Comments
 
LVL 15

Expert Comment

by:JackOfPH
ID: 18821512
A word of advice:

Instead of storing the images in your database, it is better to store the path of the image in the database.

Why? Doing so will boost system performance and you can utilize the size of the database.

Imagine, if you will store am image of size 100 kb. The size of you database will increment of 100 kb... While, If you store only the path of the image in your database the database while increment only of small amount.

Jack
0
 
LVL 15

Expert Comment

by:JackOfPH
ID: 18821538
But if you still want to do this here, have a look.

There is a link in the threads

Jack
0
 
LVL 15

Accepted Solution

by:
JackOfPH earned 50 total points
ID: 18821539
0
 
LVL 15

Expert Comment

by:JackOfPH
ID: 19155170
I think I gave him answer to his questions...
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now