[Mono-list] Re: FW: ADO.NET connection to Sybase

[tim@timcoleman.com]

Jonah,

It's good to hear that there is someone out there looking for the
SybaseClient functionality that I have been working on.  There's
good news and bad news in this department.

The good news is that work was started on the SybaseClient provider.
The bad news is that it isn't done yet. :-)

The current status of this is "unknown".  In the next day or two,
I'm going to ask Miguel to move some files around for me in CVS.
This will remedy the current situation, which is that the
Mono.Data.SybaseClient, Mono.Data.TdsClient, and System.Data 
assemblies will not coexist nicely on Linux.

Once I am able to build these assemblies on Linux, then I will
be able to go through them and get things working.  I'm not sure
how long it will take, but it's probably not that much work.  All
of the internals are mostly implemented; it's just a matter of
tweaking the provider API.

As far as I know, the only feature of TDS 5.0 used by Sybase
that I do not currently support is the use of prepared statements.
This will be fairly easy to implement.  Most of TDS 5.0 is
the same as TDS 4.2, which works for the most part.

So, the short answer is: no, it is not supported yet, but it
will be soon.  If you are intending to use this in a production
environment, however, I suggest that you hold off on that for
a while yet.  It's good to play with, but I wouldn't trust it
that much.


> Tim,
> 
> I sent this to Rodrigo before I realized that you were the man on
> Mono.Data.TdsClient (for Sybase). I'm having a hell of a time and was
> wondering if you had any info on the availability of the Sybase .net
> provider???
> Thanks in advance,
> Jonah 
> 
> 
> >  -----Original Message-----
> > From: 	Umbro, Jonah  
> > Sent:	Monday, November 18, 2002 2:59 PM
> > To:	'rodrigo@ximian.com'
> > Subject:	ADO.NET connection to Sybase
> > 
> > Hi Rodrigo,
> > 
> > I'm searching high and low for a .net provider for Sybase. It's hell!!
> > I've got the ODBC.NET provider running against Sybase System 11 driver and
> > it works but it's waaay slow.
> > 
> > I've tried several other options but nothing seems to work. I'm curious if
> > your Mono.Data.SybaseClient provider is available/freely distributed???
> > If not, any info you can give me on setting up an ADO.NET connection into
> > Sybase would be totally appreciated. I just can't believe there's no good
> > Sybase provider for .net out there! Hope to hear from you.
> > Jonah
> > 



-- 
Tim Coleman <tim@timcoleman.com>                       [43.43 N 80.45 W]
BMath, Honours Combinatorics and Optimization, University of Waterloo
Software Developer, Global Services, Open Text Corporation
"Under capitalism, man exploits man.  Under communism, it's just the
 opposite." -- J.K. Galbraith