Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004

    Unanswered: ADODB.Command (0x800A0BB9)

    I am using a stored Procedure in my ASP code to validate the login details, but i am not able to figure out what ADODB.Command(0x800A0BB9) mean. i have included the code as follows

    Stored Procedure
    create Procedure sp_Login
    @Email varchar(50),
    @Password varchar(50),

    @FullName varchar(100) output,
    @UserID int output,
    @ManageCount int output
    select @UserID = 0
    select @UserID = UserID, @FullName = FirstName + ' ' + LastName
    from Users
    where Email like @email + '%'
    and password = @Password

    if @@rowcount <> 1
    select @UserID = 0

    select @ManageCount = count(*)
    from Users
    where ManagerID = @UserID


    <%@ Language=VBScript %>
    <% SET CON=server.createObject ("ADODB.Connection")
    CON.Open "Provider=SQLOLEDB;Data Source=xxx;UID=sa;PWD=;Database=xxx"
    SET com=server.CreateObject ("ADODB.Command")

    dim UserID, ManagerCount, FullName,Mail,Pass
    Mail = Request.Form("Email")
    Pass = Request.Form("Password")

    com.ActiveConnection = CON
    com.CommandType = 4

    with com
    .Parameters.Append com.CreateParameter("@Email",adVarChar,adParamInpu t,50,Mail) ---> line 12
    .Parameters.Append com.CreateParameter("@Password",adVarChar,adParamI nput,50,Pass)
    .Parameters.Append com.CreateParameter("@FullName", adVarChar, adParamOutput)
    .Parameters.Append com.CreateParameter("@UserID", adInteger, adParamOutput)
    .Parameters.Append com.CreateParameter("@ManagerCount", adInteger, adParamOutput)
    end with
    FullName = com.Parameters("@FullName").Value
    UserID = com.Parameters("@UserID").Value
    ManagerCount = com.Parameters("@ManagerCount").Value

    ''''Error Occured

    'ADODB.Command (0x800A0BB9)
    'Arguments are of the wrong type, are out of
    'acceptable range, or are in conflict with one
    'another line 12

    Can Any one Plz Reply..

  2. #2
    Join Date
    May 2004
    values of adVarChar or adInteger are actually constants of the object and it doesn't look like you are including the file to create the constants. Here is a good link for you to read up on:

    That will tell you where to get the file and how to include a file in an asp file if you do not know how to.


  3. #3
    Join Date
    Nov 2004
    Hi Thank u very much for the solution, i worked....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts