• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1986
  • Last Modified:

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

Hi Experts,
I am getting the following error when I try to open my asp page.

Error Type:
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/FoundationNetwork/Tfn_NetAffliateUD.asp, line 14

Line 14 is
cmdUpdate.CommandType = adCmdStoredProc

<%@ Language=VBScript%>
<% Option Explicit %>
<form name= "AffiliateUD" action="Tfn_NetAffiliateUD.asp" method="post" >
Dim strConnect, adCmdStoredProc, cmdUpdate, adExecuteNoRecords
strConnect = "Driver={SQL
Set cmdUpdate = Server.Createobject("ADODB.Command")
cmdUpdate.ActiveConnection = strConnect
cmdUpdate.CommandText = "usp_Tfn_Affiliates"
cmdUpdate.CommandType = adCmdStoredProc

Open in new window

  • 2
  • 2
2 Solutions
Put the following as the very fisrt line of your file.  Before the opening script tag

<!--METADATA TYPE="typelib" uuid="00000205-0000-0010-8000-00AA006D2EA4" -->
millerfwAuthor Commented:
Tried this and I get the same error.
best bet is to include the adovbs.inc file in yur script.

I don't know the numeric value off the top of my head, but the issue you are having is because of this.  If I can find it tomorrow morning(ish) I'll post a link to the numeric values of the 'adCmdStoredProc" & "adExecuteNoRecords" for ya

<!--METADATA TYPE="typelib" uuid="00000205-0000-0010-8000-00AA006D2EA4" --> is the adovbs.inc, :)

But the problem would be redefining those constants on this line:

Dim strConnect, adCmdStoredProc, cmdUpdate, adExecuteNoRecords
-----------------------^ no --------------------------------------^ no
millerfwAuthor Commented:
I am spliting the points and reivilbiss's addition made the solution work
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now