Sybase ADO driver having problems with long strings and null
- From: philip reicher <philip.reicher@xxxxxxxxx>
- Date: Sun, 16 Jul 2006 08:21:15 -0400
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
.
- Prev by Date: Re: Sybase ADO driver having problems with long strings and null
- Next by Date: Re: Sybase ADO driver having problems with long strings and null
- Previous by thread: Re: Sybase ADO driver having problems with long strings and null
- Index(es):
Relevant Pages
|
