#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Feb 2008
    Posts
    2
    Rep Power
    0

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


    HI I'm getting this wonderful error: ADODB.Command error '800a0bb9'

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

    Here is my Stored Proc call:

    '-----------------------------------------------------------------------------------'
    '
    intFormID = "145"
    strDDName = "DrugSideEffectEducation"
    Response.Write "<br><br><br>" &intFormID

    Set objSelectCommand = Server.CreateObject("ADODB.Command")
    Set objConn = Server.CreateObject("ADODB.Connection")
    Set objSelectEduRS = Server.CreateObject("ADODB.Recordset")
    objSelectCommand.CommandType = adCmdStoredProc
    With objSelectCommand
    ' .CommandType = adCmdStoredProc
    .CommandText = "usp_FetchDropDownSelections"
    ' .Parameters.Append .CreateParameter("@FormID", adInteger, adParamInput, ,intFormID)
    .Parameters.Append .CreateParameter("@DDName", adVarChar, adParamInput, 150, strDDName)
    .Execute
    .WriteParams
    End With
    objSelectEduRS.Open objConn,,adOpenStatic, adLockOptimistic

    '-----------------------------------------------------------------------------------
  2. #2
  3. ASP Free Member
    ASP Adventurer (500 - 999 posts)

    Join Date
    Jan 2004
    Location
    Kuala Lumpur, Malaysia (Boleh!)
    Posts
    762
    Rep Power
    690
    Did you set DDName to varchar(150) at your usp_FetchDropDownSelections?
    My homepage - www.findingsteve.net

    Greatest commandment - “Teacher, which is the greatest commandment in the Law?” Jesus replied: “ ‘Love the Lord your God with all your heart and with all your soul and with all your mind.’ This is the first and greatest commandment. And the second is like it: ‘Love your neighbor as yourself.’ ” Matthew 22: 36-40 (NIV, Bible)

    Progress - "Sedikit-sedikit, lama-lama menjadi bukit." (Literal translation: Bit by bit, in the end it becomes a hill.)
  4. #3
  5. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Feb 2008
    Posts
    2
    Rep Power
    0
    yes: Here is the stored Proc-----



    set ANSI_NULLS ON
    set QUOTED_IDENTIFIER ON
    GO
    -- =============================================
    -- Author: <Author,,Name>
    -- Create date: <Create Date,,>
    -- Description: <Description,,>
    -- =============================================
    ALTER PROCEDURE [dbo].[FetchDropDownSelections]
    -- Add the parameters for the stored procedure here
    @FormID int = 0,
    @DDName varchar(150)
    AS
    BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    SELECT *
    FROM dbo.DropDownEditor
    WHERE FormID = @FormID
    And DDName = @DDName
    And Active = 1

    END
  6. #4
  7. Slaprentice of Wolves
    ASP Good Citizen (1000 - 1499 posts)

    Join Date
    Aug 2007
    Location
    Mossville, IL
    Posts
    1,469
    Rep Power
    538
    Originally Posted by msfdisk
    ' .Parameters.Append .CreateParameter("@FormID", adInteger, adParamInput, ,intFormID)
    Is this line commented out when you get the error, or was that part of trying to debug it?
    Wolffy
    ------------------------
    Opinions expressed are my own and do not necessity reflect those of any sane person. Any code provided is intended to be an example and is provided AS IS. Rework for your specific environment may be required. Void where prohibited by law. Not valid in California. Your mileage may vary. Not FDIC insured

Similar Threads

  1. Recordset printing wrong data type
    By Steve Schofield in forum .NET Development
    Replies: 2
    Last Post: April 20th, 2005, 12:12 PM
  2. Data type mismatch with UPDATE what's wrong
    By wdale in forum ASP Development
    Replies: 1
    Last Post: August 16th, 2004, 10:52 AM
  3. Replies: 2
    Last Post: May 24th, 2004, 06:59 AM
  4. Arguments of wrong type?
    By Jamo in forum ASP Development
    Replies: 0
    Last Post: August 11th, 2003, 10:21 AM
  5. error - out of acceptable range
    By tonya in forum ASP Development
    Replies: 4
    Last Post: April 24th, 2003, 06:49 PM

IMN logo majestic logo threadwatch logo seochat tools logo