I've got this code in my asp...
<%
Dim Conn, sSQL, nextRef
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "BlahBlah","Username","Password"
Set Cmd = Server.createObject("ADODB.command")
Set Cmd.ActiveConnection = Conn
cmd.CommandText="usp_saveaddress"
cmd.CommandType = adCmdStoredProc
cmd.Parameters.Append cmd.CreateParameter("RetVal", adInteger, _
adParamReturnValue)
cmd.Parameters.Append cmd.CreateParameter("param1", adInteger, _
adParamInput)
cmd.Parameters.Append cmd.CreateParameter("param2", adInteger, _
adParamInput)
cmd.param1=Request.Form("Surname")
cmd.param2=Request.Form("Forname")
Cmd.Execute
Response.Write "
Thank you. Your information has been added to our database!
"
%>
It doesn't like this line though.
cmd.CommandType = adCmdStoredProc
It gives me error messages saying...
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Do you have any idea what's going on here?
I don't.