hello..i have to call a stored procedure from an ASP page which has an only input parameter and doesnt return any value..... and the code i wrote is as below..
Dim objConn
Dim objCmd
Set objConn= Server.CreateObject("ADODB.Connection")
Set objCmd= Server.CreateObject("ADODB.Command")
objConn.Open "Driver={SQL Server}; Server=66.66.666.666\test; Database=mydatabase; UID=myuser; PWD=mypwd;"
Set objCmd.ActiveConnection = objConn
objCmd.CommandText = "my_test"
objCmd.CommandType = adCmdStoredProc
objCmd.Parameters.Refresh
objCmd.Parameters(0) = "test"
objCmd.Execute
i dont know much ASP and now its hitting a below error...please suggest me where am i going wrong..or tell me a good approach to get succeeded....
ADODB.Command error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/myfolder/mypage.asp, line 49
thanks for any kind of help in advance..