[Mono-list] Sybase and Microsoft SQL Server database support in Mono ADO.NET

Rodrigo Moya rodrigo@ximian.com
16 Oct 2002 17:02:40 +0200

On Wed, 2002-10-16 at 16:43, Tim Coleman wrote:
> On Wed, Oct 16, 2002 at 09:59:25AM -0400, Daniel Morgan wrote:
> > Hey,
> > 
> > Currently, ADO.NET in Mono does not support Sybase nor Microsoft SQL Server.
> > Unless, you want to use System.Data.Odbc with unixODBC with FreeTDS on
> > Linux, System.Data.OleDb with libgda with FreeTDS on Linux, or with the
> > native ODBC support and MDAC on Windows.  However, this adds a lot of
> > dependencies, configurations, and another layer for data to have to travel
> > degrading performance.
> > 
> > I would like to create a provider for Microsoft SQL Server in
> > System.Data.SqlClient and for Sybase in Mono.Data.SybaseClient.  It will use
> > the native FreeTDS libraries to provide this capability.  In order to use
> > FreeTDS, we will need to create C# bindings to FreeTDS.
> >
> > [...]
> >
> > The best approach is to create a pure managed provider in C#, but who has
> > the time to implement the TDS protocol in C#?  In the meantime, we can use
> > the native FreeTDS libraries for this.
> > There is jTDS at http://www.freetds.org/ but that involves time porting from
> > Java/JFC/JDBC to the C#/.NET/ADO.NET stuff.
> > 
> > [...]
> >
> > The importance for FreeTDS and Mono running on Windows is that a developer
> > may have only one machine (me) to develop Mono, and Microsoft SQL Server
> > only runs on Windows.  So, the development would have to be done on Windows.
> > 
> > Anybody willing to help?
> At one point in the past I looked at creating a libgda provider for
> FreeTDS.  Unfortunately, I ran out of time :).  I would like to help
> create a provider for FreeTDS in mono.  I'm not sure that going through
> libgda is the correct approach though.
it's not going through libgda, but it's gonna use the TDS protocol
directly, either via FreeTDS or talking it directly (if we port jTDS).

> I do have Windows and Microsoft SQL Server, however I don't see why
> developing a SQL Server provider requires development to be done on
> Windows.  It would require that the developer have SQL Server available
> on a network, but that's all. 
yes, that's all. In fact, if we use FreeTDS, having a Sybase database
server available would also help.

Rodrigo Moya <rodrigo@ximian.com>