ADODB.Command (0x800A0BB9) - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

ADODB.Command (0x800A0BB9)

Author

Topic

Krb_iiaba
Starting Member

16 Posts

Posted - 2004-02-19 : 15:20:27

Trying to execute a SP from ASP page and receiving this error

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

CODE
Line 53: cmdAgency.Parameters.append cmdAgency.CreateParameter("@CounterName",adVarChar, adParamInput, 30, "NAME")

Any suggestions?

X002548
Not Just a Number

15586 Posts

Posted - 2004-02-19 : 15:23:02

Do you know the paramter list of the sproc?

I'd say you're trying to pass char data to either a numeric or date required parameter.

Brett

8-)

Krb_iiaba
Starting Member

16 Posts

Posted - 2004-02-19 : 15:24:59

@CounterName varchar(30)

MichaelP
Jedi Yak

2489 Posts

Posted - 2004-02-19 : 16:17:15

adVarChar, adParamInput are not definded as constants in ASP.
you either need to find and #include the ado_vbs.inc or look up the numeric values for those two constants and put those into your page.

adVarchar = 200
adParamInput = 1

Try this:


("@CounterName",200, 1, 30, "NAME")

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-02-19 : 16:40:20

Another alternative to Adovbs.inc is Type Libraries:

http://www.asp101.com/articles/john/typelibs/default.asp

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources