I have an update stored procedure and when I call it in my vb program I get the run time error: -2147217900[Microsoft][odbc sql server driver][sql server]line 1: incorrect syntax near '12345'. where 12345 is the first textbox entry in the form I am using to update:
adoConnection.Execute "TEST_UPDATE('" & Text1.Text & "','" & Text2.Text & "','" & Text3.Text & "','" & Text4.Text & "','" & Text5.Text & "','" & Text6.Text & "')"
Something suprising is that I have another stored procedure used to update a small table, ti works but with the 19 columns table I get that message.
What am I doing wrong.
Help urgently needed.