Notices

Great community. Great ideas.

Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.

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

Results 1 to 4 of 4
Share This Thread →
  1. #1
    msfdisk is offline Registered User
    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
    ngaisteve1's Avatar
    ngaisteve1 is offline ASP Free Member
    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.)

  3. #3
    msfdisk is offline Registered User
    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

  4. #4
    Wolffy's Avatar
    Wolffy is offline Slaprentice of Wolves
    Join Date
    Aug 2007
    Location
    Mossville, IL
    Posts
    1,469
    Rep Power
    538
    Quote 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

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

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

ASP Free Advertisers and Affiliates