Link to home
Start Free TrialLog in
Avatar of arunatata
arunatata

asked on

Getting a 800a0bb9 error when I call a stored procedure

I am trying to run a stored procedure from my ASP page and get the following error

ADODB.Command error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

Projectabc/LoginValidate.asp, line 20

Line 20 is the line that goes "Set ObjParam1=......"

<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<%
UserName = Request("UserName")
Password = Request("Password")

Set myRS=Server.CreateObject("ADODB.Recordset")
Set ObjCmd = Server.CreateObject ("ADODB.Command")
Set StrConn=Server.CreateObject("ADODB.Connection")
DText="Provider=SQLOLEDB;Server=strServer;Initial Catalog=strCat;User ID=User;Password=abc"
StrConn.Open Dtext

objCmd.ActiveConnection=strConn
ObjCmd.CommandText = "sp_ValidateUserLogin"
ObjCmd.CommandType = 4
Set ObjParam1 = ObjCmd.CreateParameter("RequiredLogin",adVarChar,adParamInput,64)
objCmd.Parameters.append objParam

Set ObjParam2 = ObjCmd.CreateParameter("RequiredPassword",advarchar,adParamInput,64)
objCmd.Parameters.append objParam2


objCmd.Parameters("RequiredLogin") = UserName
objCmd.Parameters("RequiredPassword")=Password


Set myRS= objCmd.Execute

While not myRS.EOF
Response.Write myRS("Name")
myRS.MoveNext
Wend

%>
</BODY>
</HTML>
ASKER CERTIFIED SOLUTION
Avatar of fritz_the_blank
fritz_the_blank
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of arunatata
arunatata

ASKER

Got it thanks!!
Glad to have helped,

FtB