inserting ntext sql field from Visual Basic 6.0 1

[msilka]

I have a SQL 2000 database table with an ntext field.
I want to execute a stored procedure from VB 6.0 that will
insert a record into this table.

I created an ado command object in VB and appended the parameters for the fields which I will be inserting.

For the ntext field what is the TYPE variable for the CreateParameter statement?

Thank you

 

[jebenson]

It is adLongVarWChar

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

 

[msilka]

Thank you,

It works great now!!