How to save image in database?

Question

0.00/5 (No votes)

See more:

<br />
Private Sub save_Click()<br />
Set Picture1.DataSource = Rs<br />
Picture1.DataField = "DOC"<br />
<br />
strSQL = "insert into LOB_TABLE(DOC)"<br />
strSQL = strSQL + "values(" & Picture1.Picture & " ) "<br />
strSQL = strSQL + "where ID = 1"<br />
Set Rs = Cn.Execute(strSQL)<br />
    MsgBox ("picture saved in table")<br />
Rs.Close<br />
End Sub<br />

Run-time error :
SQL command not properly ended......
In Watch Window:

?strsql
insert into LOB_TABLE(DOC)values( & Picture1.Picture ) where ID = 1
or
insert into LOB_TABLE(DOC)values(-184217824) where ID = 1

Please help.........

Posted 28-Jan-13 0:15am

surkhi

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Accepted Answer · 2013-01-28T04:47:00

You have been given several alternatives for solutions in the other 4 postings of this same question.
See answers and comments to the following questions...
How to insert picture into oracle[^]
How to code for BLOB ?[^]
How to load and retrieve picture using vb and oracle[^]
How to load Picture in database?[^]

Here is yet another article on the subject
Save and Retrieve Image from a SQL Server Database using VB.NET[^]

As we've pointed out several times you can't just stick a picture into the SQL and hope for the best. I suggest that you look at the code from one of the links above and compare what you are doing with what they did and track down your errors that way.

Don't worry if the solutions are for SQL Server rather than Oracle - the difference in this case is somewhat trival.

As to the specific error above "SQL command not properly ended" I don't think you got this issue when you typed into the Immediate window the second time. Again - see comments to previous posts by you