invoke stored sql procedure, from vb2005, with parameters

[vernon]

the following code, in a vutton click, successfully calls a stored procedure in sql server..


Dim strconn As String
strconn = "Provider=SQLOLEDB;DATA SOURCE=" + sDataSource + ";initial catalog = madisonavenuefurniture;Trusted_Connection=yes;"
Dim cn As New OleDb.OleDbConnection(strconn)
cn.Open()
Dim cmd As New OleDb.OleDbCommand("pPONumberWrite", cn)
cmd.ExecuteNonQuery()
however

when I amend it to try and pass parameters to the stored procedure, the parameters are not seen...

Dim strconn As String
strconn = "Provider=SQLOLEDB;DATA SOURCE=" + sDataSource + ";initial catalog = madisonavenuefurniture;Trusted_Connection=yes;"
Dim cn As New OleDb.OleDbConnection(strconn)
cn.Open()
Dim cmd As New OleDb.OleDbCommand("pPONumberWrite", cn)
cmd.Parameters.AddWithValue("@P1", "2")
'cmd.Parameters.AddWithValue("@P2", "1649")
cmd.ExecuteNonQuery()

whynot?

help

[scripto]

have you amended the stored procedure to accept the parameters???

[vernon]

have you amended the stored procedure to accept the parameters???

yes... believe I have. Executed from object explorer in server managment studio, it asks for parameter value, and works well!

[scripto]

well your code looks ok - can we see the stored proc?