Upload Image File to SQL

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!
LVL 1
jayh99Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JackOfPHCommented:
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
JackOfPHCommented:
But if you still want to do this here, have a look.

There is a link in the threads

Jack
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JackOfPHCommented:
I think I gave him answer to his questions...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.