SQL Server / SP / Text datatype

[stnkyminky]

Im trying to insert text into a table with a field defined as text. What datatype do I use when executing the SP from VB? adChar exists but not adText
Also what is the length as I didnt need to specify one in my SP. Scott
Programmer Analyst
<><

 

[bjd4jc]

I would use adVarChar

Are you required to specify the length?

If you are I would put Len(Variable) in for the length.

 

[haysie]

if you're populating an SQL Server text field I'd be tempted to use adLongVarChar