[Mono-dev] Connection to a sybase ASA database

[Mads Bondo Dydensborg]

mandag 11 december 2006 18:48 skrev Daniel Morgan:
> Ah.  I missed that part in your email earlier. 

No wonder - I am blaming sybase for using acronyms that so much look the same, 
for two products that are fundamentally quite different.

> 
> Currently, ASA (Sybase SQL Anywhere) does not work. 

OK - I guess, that if one knows that, it is documented in the web pages - 
however, I did not know that ;-) 

Since you seem to know: What is the recommended way of connecting to a Sybase 
ASA 9.0.2 database? ODBC? (What class in mono should I use - I am honestely 
confused. Sorry about that ;-)

> Perhaps it is with unicode or lack of unicode encoding
> or language or character set.  Maybe the TDS protocol
> is different and something needs to be set.  Not sure
> what TDS protocol version sybase asa uses.  I would
> visit the freetds or jtds projects to see.

I already traced the communication between mono (sqlsharp) and an ASA 
9.0.2/10.0.0. It _almost_ works for 10.0.0 - that is, you can connect (first 
connection fails, but doing a connect again works), you can issue sql 
statements, but mono (apparently) fail to understand the result. The 
statements are executed though - at least the server reports they are.

Both of these servers claim to at least support TDS 4.2.0 and 5.0.0.

> I did a search on google, and this came up.
> 
> http://lists.ximian.com/pipermail/mono-devel-list/2006-June/018712.html
> 
> Care to add a bug in bugzilla please?
> 
> http://bugzilla.ximian.com/

Tried: bug 80232

Regards,

Mads

-- 
Med venlig hilsen/Regards

Systemudvikler/Systemsdeveloper cand.scient.dat, Ph.d., Mads Bondo Dydensborg
Dansk BiblioteksCenter A/S, Tempovej 7-11, 2750 Ballerup, Tlf. +45 44 86 77 34