PegasusAloft
asked on
Long Varchar Field Driving Me Batty in C#!
I’m trying to retrieve a Long Varchar column from a Sybase Adaptive Server Anywhere 9 database in a C# client application using the .NET OleDB libraries.
I’ve tried both OleDBDataReader and OleDBDataAdapter. I don’t get an error when executing the query, but when attempting to retrieve the Long Varchar field, I get a length of zero from the DB using OleDBDataReader.GetChars, and when attempting to cast into a string, I end up with the empty string.
If I shorten the data in the field to 20 or 30 characters, it works. But at some threshold, the data is too big and I can’t retrieve the data. The data I’m trying to retrieve is around 10,000 characters.
Any ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.