ADO.Net - Sybase 11 - getting contents of TEXT field from a DataSet into a String

[Bryan Donaldson]

Situation - ASP.Net application using VB.Net connecting to Sybase 11
database using Sybase ASE OLEDB provider

I've got a DataSet being returned that contains one table (actually a view
whose definition contains several joins). That table contains a few
columns which in Sybase are defined as TEXT.

When I view the contents of the DataRow returned from the query, the TEXT
fields contain "trash". What are the gyrations I need to go through to get
the real contents of the TEXT fields?

(As far as I can tell - the contents are not Unicode - the code points when
I look at them are not valid for the text that I can see is in the field
from the source application.)

 

[Val Mazur]

Hi Bryan,

Basically you should not do anything. When you retrieve data from the
database, you DataSet should get just plain text. I think it could be some
sort of provider's issue. Did you try to find something on a Sybase site?
Which version of Sybase server are you using? I will try to reproduce it on
my server as well

 

[Bryan Donaldson]

Actually, yes I did..

http://info.sybase.com/resolution/detail.stm?id_number=10916414

I'm currently using the 12.1 or 12.0 drivers. This article from SYBASE
implies that, even though they dont support .Net, upgrading to 12.5 drivers
and applying an EBF might resolve the issue.