Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

String truncation when calling stored procedures from Active Server Pages

0 views
Skip to first unread message

Kevin Hatcher

unread,
Sep 19, 1997, 3:00:00 AM9/19/97
to

Can anyone help.

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...

0 new messages