Create Parameters DataType help

Hi

I am creating a Parameter for my Command Object. In my database, the field is of type ntext with a length of 16.

When I use the .CreateParameter method (I am using the shortcut text here..), what is the DataTypeEnum for it? Is it adVarChar 16 or what?


.Parameters.Append .CreateParameter("@strComments", adVarChar, adParamInput, 16)

sanctos

Here is the list of DataTypeEnums.

DataTypeEnums

thanks, now there is another issue:

I have created the parameter as such...

.Parameters.Append .CreateParameter("@strComments", adLongVarChar, adParamInput, 1000)

When I go to execute my command object, I am getting this error:

Microsoft OLE DB Provider for SQL Server error '80040e14'
Syntax error or access violation
[My File].asp, line 'whatever'

Let me know if you want the stored procedure info

sanctos

is the error referencing the paramenter.append line of code?