Application type error - does not make sense

I have a inquiry form that works perfectly under nearly every condition I
test. Yet, I seem to be getting increasing error messages from users and I
cannot figure out the cuase of the problem:
ERROR

ADODB.Command error '800a0d5d'

Application uses a value of the wrong type for the current

operation.

/globalincludes/inquire/pInquire_Execute.asp, line 306
CODE

Sub
.....
oCmd2.Parameters.append oCmd2.CreateParameter("u_browser", advarchar,
adParamInput,70,sBrowser)
--
End Sub
DATABASE

u_browser, varchar(100) Yes - Allow Nulls
CONCLUSION:
It does not make sense. I have the right data type and the database field is
bigger than the Sp size constraint...

Any ideas?

Many thanks
Jason

[Ray Costanzo [MVP]]

Do you have "advarchar" defined anywhere? Do you not use Option Explicit in
your code? Tsk tsk tsk! :]

Const advarchar = 200
Const adParamInput = 1

This is my guess anyway.

Ray at work

<ja***@catamaranco.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

I have a inquiry form that works perfectly under nearly every condition I
test. Yet, I seem to be getting increasing error messages from users and I
cannot figure out the cuase of the problem:
ERROR

ADODB.Command error '800a0d5d'

Application uses a value of the wrong type for the current

operation.

/globalincludes/inquire/pInquire_Execute.asp, line 306
CODE

Sub
....
oCmd2.Parameters.append oCmd2.CreateParameter("u_browser", advarchar,
adParamInput,70,sBrowser)
--
End Sub
DATABASE