What Is The ADO DataType For NVarchAR(max)

I can't seem to get nvarchar(max) to work with ADO 2.8 using sql native client.

I am creating a stored procedure and every time i attempt to add a parameter to the command object of type nVarChar(max) I receive the error

"Parameter object is improperly defined"

here is the code to add the parameter

cmd.Parameters.Append cmd.createparameter(@piComments,adLongVarWChar,adparaminput,,me.comments)



adLongVarWChar is the ado data type i am using to map to the new nVarChar(max) but it does not appear to be working.

Is this supported in ADO? I am using the sql native client connection to connect to the database as follows.

pubStrConnectionString = "Provider=SQLNCLI;" _
& "Server=.sqlExpress;" _
& "Database=MyDBName;" _
& "Integrated Security=SSPI;" _
& "DataTypeCompatibility=80;" _
& "MARS Connection=True;"




thanks