Getting a 800a0bb9 error when I call a stored procedure

Posted on 2004-11-10
Last Modified: 2012-05-05
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 %>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
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.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

Set myRS= objCmd.Execute

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

Question by:arunatata
    LVL 46

    Accepted Solution

    Are you using the file? If not, you need to use the numeric constants instead of adVarChar, adParamInput and etc.


    Author Comment

    Got it thanks!!
    LVL 46

    Expert Comment

    Glad to have helped,


    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Suggested Solutions

    I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
    I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    This video discusses moving either the default database or any database to a new volume.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now