[Mono-list] ODBC.NET Data Provider

Daniel Morgan danmorg@sc.rr.com
Tue, 8 Oct 2002 23:11:06 -0400


Being able to connet to a database and do queries is a milestone in itself.
It wouldn't hurt to go ahead and check it into cvs.  Besides, I feel safer
anything I have worked on has been put into cvs because I know Ximian guys
keep things backed up unlike my computer. :-)

I don't know what the namespace or assembly for the ODBC provider in .NET
1.1, but the MSDN download of the ODBC provider for .NET 1.0 uses
Microsoft.Data.Odbc as the namespace and Microsoft.Data.Odbc.dll as the
assembly name.

We have SQL# which is a command-line SQL query tool written in C# that can
connect to various databases using the various ADO.NET providers.  It can be
at mcs/class/System.Data/Test/SqlSharpCli.cs   However, don't be to
disappointed in the tool, it was mainly meant for testing Mono's

What would be nice is to have a MS SQL Server 2000 Enterprise Manager, Query
Analyzer, or TOAD like tool for Mono System.Data written in C# and using


-----Original Message-----
From: mono-list-admin@ximian.com [mailto:mono-list-admin@ximian.com]On
Behalf Of Brian Ritchie
Sent: Tuesday, October 08, 2002 9:39 PM
To: danmorg@sc.rr.com; mono-list@ximian.com
Subject: RE: [Mono-list] ODBC.NET Data Provider

Sounds good, I've got a little more work before I send in the patch.  I
don't want to send in anything that is too raw :)

Has anyone looked at .NET 1.1 yet?  I'm assuming they are moving the Odbc
stuff under the System.Data namespace...so that is how my stuff is setup.

Have you guys talked about providing any basic db tools with the mono
framework?  Like a isql-style command line tool?  This might be a good way
for people to test their database connections, etc.

Keep up the good work guys...the framework is looking good.


>From: "Daniel Morgan" <danmorg@sc.rr.com>
>To: "Brian Ritchie" <brianlritchie@hotmail.com>, <mono-list@ximian.com>
>Subject: RE: [Mono-list] ODBC.NET Data Provider
>Date: Mon, 7 Oct 2002 01:08:32 -0400
>This is good news.
>Can provide us with a patch please in an email to the mono-list@ximian.com?
>If you don't know how to make a patch, you can look here on how:
>This way people can get a preview of your work and be able to help
>contribute too.  Since unixODBC supports so many databases, it will
>definitely be appreciated.
>Do you know if unixODBC works on Windows?
>-----Original Message-----
>From: mono-list-admin@ximian.com [mailto:mono-list-admin@ximian.com]On
>Behalf Of Brian Ritchie
>Sent: Monday, October 07, 2002 12:02 AM
>To: danmorg@sc.rr.com; mono-list@ximian.com
>Subject: RE: [Mono-list] ODBC.NET Data Provider
>Thanks for the quick response.  I have basic implementations of
>OdbcConnection, OdbcCommand, OdbcDataReader, OdbcParameter, and
>OdbcParameterCollection.  It can execute queries and display result sets
>(and ExecuteNonQuery too).  I'm currently working on the Parameter &
>Transaction support.  I've been doing my development on Debian against a
>7.2 UDB.
> >From: "Daniel Morgan" <danmorg@sc.rr.com>
> >To: "Brian Ritchie" <brianlritchie@hotmail.com>, <mono-list@ximian.com>
> >Subject: RE: [Mono-list] ODBC.NET Data Provider
> >Date: Sun, 6 Oct 2002 22:51:07 -0400
> >
> >Brian
> >
> >No one is working on the ODBC.NET Data Provider as far as i know.  Just
> >attach your diff in an email, and someone, such as (passing the buck -
> >hehehe) Rodrigo Moya can do that for you. Rodrigo is the coordinator for
> >the
> >ADO.NET technology in Mono.
> >
> >What can you do witht he provider so far?  Can you connect to a database
> >yet?  How about run any queries?  Or is it just C# bindings to the
> >library(ies) right now?
> >
> >Daniel
> >
> >-----Original Message-----
> >From: mono-list-admin@ximian.com [mailto:mono-list-admin@ximian.com]On
> >Behalf Of Brian Ritchie
> >Sent: Sunday, October 06, 2002 10:03 PM
> >To: mono-list@ximian.com
> >Subject: [Mono-list] ODBC.NET Data Provider
> >
> >
> >Is anyone working on a ODBC data provider?  I've started one using
> >and I'd like to contribute it to the project.
> >
> >Brian