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

    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
    )
    As
    select @UserID = 0
    select @UserID = UserID, @FullName = FirstName + ' ' + LastName
    from Users
    where Email like @email + '%'
    and password = @Password

    if @@rowcount <> 1
    begin
    select @UserID = 0
    return
    end

    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.commandtext=sp_login
    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
    Posts
    125
    values of adVarChar or adInteger are actually constants of the object and it doesn't look like you are including the adovbs.inc file to create the constants. Here is a good link for you to read up on:

    http://msdn.microsoft.com/library/de...invbscript.asp

    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.

    HTH
    DMW

  3. #3
    Join Date
    Nov 2004
    Posts
    3
    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
  •