How come this snippet of code works fine in VB6, however, when I run it in ASP I get the following error message?
Error Message.Code:.Parameters.Append .CreateParameter("@State", adVarChar, adParamInput, 25, "Arizona")
[Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'CheckState' expects
parameter '@State', which was not supplied.
Inside the stored procedure I have a parameter called @State.
Am I adding a new parameter to the already existing parameter? I'm confused and any help would be appreciated. Thank you.




Reply With Quote