[Mono-list] IBM has an ADO.NET provider for IBM DB2 Universal Database in Beta

[Daniel Morgan]

Hello,

IBM has available for download a Beta of an ADO.NET data provider for IBM
DB2 Universal Database.

Here is an excerpt from their page:

    IBM DB2 .NET Provider (Beta)

    The DB2 .NET Data Provider is an
    add-in component to the Microsoft® .NET Framework. This
    provider accesses IBM DB2 database
    servers running on variety of hardware and operating
    system platforms.  Specifically, the DB2 .Net Data
    Provider can be used to provide connectivity from
    applications written using ADO.NET API to the
    following DB2 family servers:

    DB2 Universal Database Version 8.1
    running on Windows, UNIX and Linux

    DB2 Universal Database for z/OS and OS/390 V6.1
    and later (requires DB2 Connect V8.1)

    Note: DB2 Server for VSE & VM and IBM DB2 Server
    for iSeries will be supported at a later date

Unfortuantely, it is designed for .net on Windows.  It would be nice if IBM
made a version available for Mono.

IBM's .net data provider for IBM DB2 (Beta) has
an assembly name IBM.Data.DB2.dll
and uses a namespace IBM.Data.DB2.

http://www7b.software.ibm.com/dmdd/downloads/dotnetbeta/

Mono has its own implementation named Mono.Data.DB2Client.
It has a namespace DB2ClientCS and an assembly name Mono.Data.DB2Client.dll.
Maybe, the namespace DB2ClientCS should be renamed to Mono.Data.DB2Client.

Mono's IBM DB2 data provider should be made compatible with IBM's IBM DB2
data provider.

http://www.go-mono.com/ibmdb2.html

Mono has an ODBC provider as well which is similar to Microsoft's ODBC .net
provider and
similar to the IBM DB2 provider which can be used to connect to IBM DB2.

http://www.go-mono.com/odbc.html

Due to the current documentation for IBM DB2's provider (beta) is not
complete,
they mention use the documentation for Microsoft's ODBC .NET data provider
for reference.
The final version of IBM DB2's provider will contain full documentation
though.

The only documentation I know Microsoft has for the ODBC .NET Data Provider
is included with the actual ODBC .NET Data Provider
which is

- an add-on component to the .NET Framework 1.0
  as Microsoft.Data.Odbc
  and is part of assembly Microsoft.Data.Odbc.dll
- included with .NET Framework 1.1 or Visual Studio.net 2003
  as Sysystem.Data.Odbc
  and is part of assembly System.Data.dll

http://msdn.microsoft.com/library/default.asp?url=/downloads/list/netdevfram
ework.asp

However, Mono has their ODBC has System.Data.Odbc in the System.Data.dll
assembly.

Daniel