unable to update field with more than 126 characters

  • Thread starter Thread starter Shawn
  • Start date Start date
S

Shawn

Hi.
I have a stored procedure in my Sybase 11.9, but I get an error when I try
to update a row. This happends when I have more than 126 chars in one of my
parameters. The parameter is declared varchar(254) and so is the field that
I'm trying to update.

This is the error I'm getting:
[Native Error code: 21] [DataDirect ADO Sybase Provider] WARNING - Fatal
Error 4020 occurred at Feb 4 2005 10:21AM. Please note the error and time,
and contact a user with System Administrator (SA) authorization.

Does anyone know what causes this?
 
For some reason I had to specify the lenght of the OleDbParameter to be 254.
This has never been an issue before so I think it's because I had upgraded
to a newer Sybase OLEDB provider (Sybase 12.5.1)

Shawn
 
Back
Top