ADO 2.7 truncation on fields greater than 255 in Sybase

[braidj]

Hi,

using VB6, connecting to a 12.5.0.1 Sybase database and
Microsoft ActiveX Data Objects 2.7 Library.

When I query a sybase Text field through an ADODB.recordset
it returns empty values for that field, despite there being
data.

I am unable to insert text into that field greater than 255 char in length. If I query a varchar field greater than 255
the resultant data is truncated back to 255.

Any ideas gratefully received.

Kind Regards

Jason

 

[paulbent]

Have you tried GetChunk and AppendChunk? There are some sample VB functions at

http://support.microsoft.com/support/kb/articles/q197/9/75.asp

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[Swi]

It may be because it is scanning only the first few rows of the recordset and making a determination based on those rows. Here is more information about what I am talking about and solutions to the problem. This references Excel but this may be a similar problem.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;189897

Swi