Has anyone been able to use ado command with sql server 6.5 readtext,
writetext, and updatetext to manipulate text field (>255 characters) with vb
5.0?  What do you specify for the ado command type (adLongVarChar or
adVarChar) ?

Your help is greatly appreciated.

Rich Cheng

Rich,

You shouldn't use WriteText etc., anymore with ADO. You can use normal
INSERT and EDIT statements. For parameters use the adLongVarchar. Note that
if you use parameters and the field is empty, you still have to set a size
property of the field.

Later...

Niels

Niels,

What would the size be  for a SQL TEXT field?
Cal Evans