I am trying to call an SQL stored procedure from VB Server side script
in an active server page (.asp).
Everythings O.K. except when I try to pass a string longer than 256
characters to a stored procedure which takes it as a text parameter and
inserts it into a field of type text ( lenght 16).
The error message I get when the stored procedure is called is
[Microsoft][ODBC SQL Server Driver]String data right truncation
I've been told to give up and not use an text data type but I'm sure
there must be a way...