Sybase ADO driver having problems with long strings and null
- From: philip.reicher@xxxxxxxxx
- Date: 14 Jul 2006 13:25:13 -0700
We are in the process of switching our sybase clients. Currently we
are using an older Sybase client. It has the older datadirect ADO
provider (Sybase.ASEOLEDBProvider). My current code handles
Varchar(255) and Text fields and nulls without any problems using the
standard Delphi 7.0 ADO components.
When I am testing with the new client uses Sybase's ADO provider
(ASEOLEDB). My code loads fine in reading the data. When I try to
update a large Varchar or Text field I get the following error.
"Multiple-step OLE DB operation generated error. Check each DB status
value, if available. No work was done"
When a field is nulled out by setting the parameter to Null, I get the
following error.
"Data overflow. Increase specified column size or buffer size."
If I remove the large string fields from the query, everything works.
1) I do set the datatypes (in the case of strings it is ftString)
2) If the field is null, I assign "Null" to the val of the parameter
.
- Follow-Ups:
- Re: Sybase ADO driver having problems with long strings and null
- From: Riki Wiki
- Re: Sybase ADO driver having problems with long strings and null
- Prev by Date: Re: ms sql null values
- Next by Date: Re: ms sql null values
- Previous by thread: ms sql null values
- Next by thread: Re: Sybase ADO driver having problems with long strings and null
- Index(es):
Relevant Pages
|
