[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.
cheers
--
Rodrigo Moya <rodrigo@ximian.com>