[Mono-dev] Mono.Data.SybaseClient

[Troy Hamilton]

On Thu, Apr 21, 2011 at 1:09 AM, Quandary <quandary82 at hailmail.net> wrote:

> Probably it was removed because it doesn't work with ASE 15.5, which is the
> current version.
> I tried it, and it just didn't work.
>

We're using Sybase 15.5 and the database server apparently goes into
backwards-compatibility mode depending on the capability flags that the
driver sends, but in this compatibility mode, it does not support any
features added after about version 12.5x.

If you find a driver that works, let me know.
> I wanted to try how compatible Sybase is with MS-SQL, since they have a
> common ancestor.
>

I had that idea, too, and I've seen it suggested in some pretty old forum
postings and mail lists, but the protocols seem to have diverged too much
over time because I haven't been able to get it working with either the Mono
or .NET MS-SQL server drivers.  The jtds driver covers both servers because
it does a lot of conditional processing based on both the jdbc connection
string and packets returned from the server.


> Couldn't get Sybase to work with Ubuntu 10 (worked fine on 9), but 10.10's
> anyway a desaster.
> Looking forward to v11, coming April 28/29. Else I'm switching back to good
> old Debian.
>

So far, I've only been working in .NET on Windows, but I'll try it in mono
on linux if/when I get it working.

My understanding is that Sybase sells their .NET driver, but that only
> together with a support contract (& accompanying download login) that you
> don't really need, and there is no telling whether that .NET driver works on
> Linux.
>

We've got a Sybase support contract, so I've been able to test their .NET
driver.  It works, but it is horribly slow.  It is slightly faster than
their OLEDB driver in some cases and slower in others.  But I don't think it
will ever work on linux because the Sybase ADO.NET driver is actually just a
managed wrapper around their unmanaged windows driver.

I'll keep you informed if I'm able to make any more progress with updating
the mono driver to work with 12.5 and greater.


Cheers,

Troy
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-devel-list/attachments/20110421/72787b2e/attachment.html