Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    2

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

    Hey guys and gals. I have a problem with some code. I have had many different problems with all the sites I've done here and there, but I have never had a problem on the line described below. Here are the details:

    Site:

    http://www.poe-boy.com

    Error Message:

    ADODB.Command error '800a0bb9'

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

    /artiststore.asp, line 14


    Page Info:

    Line 11: Set cmd = Server.CreateObject("ADODB.Command")
    Line 12: cmd.ActiveConnection = dbc
    Line 13: cmd.CommandText = "qryNumberOfProduct"
    Line 14: cmd.CommandType = adCmdStoredProc


    Also, when i fisit another page, I get the same type of error for the same code that is on line 14. What I can't explain is that the site was working properly about 2 hours before I found the error.

    Thanks in advance.

  2. #2
    Join Date
    Mar 2004
    Posts
    1

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

    try adding

    Const adCmdStoredProc = 4

    to you script

  3. #3
    Join Date
    Mar 2004
    Posts
    2

    Thank

    Yeah Johnno. I reuploaded mu adovbs.inc file and everything worked fine, I guess something happened to it before. Thanks alot.

Posting Permissions

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