unable to update field with more than 126 characters

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?
 
S

Shawn

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,769
Messages
2,569,581
Members
45,056
Latest member
GlycogenSupporthealth

Latest Threads

Top