Hey All,
Here is my code:
I'm getting an Error on the ExecuteNonQuery command:Code:odcQuote.Open() odcmQuote = New Odbc.OdbcCommand odpQuote = New Odbc.OdbcParameter odcmQuote.Connection = odcQuote odcmQuote.CommandText = strSPName odcmQuote.CommandType = CommandType.StoredProcedure odpQuote.ParameterName = strSPParamName odpQuote.OdbcType = Odbc.OdbcType.Int odpQuote.Value = intParamVal odpQuote.Direction = ParameterDirection.Input odcmQuote.Parameters.Add(odpQuote) odcmQuote.ExecuteNonQuery() odcQuote.Close()
"The Stored Procedure *whatever* requires a parameter named @intQotID"
Which is true, but that parameter I add is definatley named "@intQotID". Any idea why it isn't recognizing it?
Thanks!
--Ben




Reply With Quote