call update stored procedure

I have an update stored procedure to update 19 columns and when I run it in my VB program I get the run time error :
-2147217900[microsft][odbc sql server driver][sql server]Line1: incorrect syntax nera '12345'.

adoConnection.Execute "TEST_UPDATE('" & Text1.Text & "','" & Text2.Text & "','" & Text3.Text & "','" & Text4.Text & "','" & Text5.Text & "','" & Text6.Text & "')"

I tested the other stored procedure using a six column table it worked ok. Now what am I doing wrong.

Thank you.
Help urgently needed.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories