web/oledb

   1 * OLE DB Provider
   2 <ul>
   3         <li> Provides a OleDb-like provider for Mono
   4         using <a href="http://www.gnome-db.org/">GDA</a> as the data access layer.
   5
   6         <li> Exists in namespace System.Data.OleDb and assembly System.Data
   7
   8         <li>Created by Rodrigo Moya
   9
  10         <li>LibGDA has providers for:
  11         <ul>
  12                   <li><a href="http://www.mysql.com/">MySQL</a>
  13                   <li><a href="http://www.postgresql.org/">PostgreSQL</a>
  14                   <li>XML
  15                   <li>ODBC (via <a href="http://www.unixodbc.org/">unixODBC</a>)
  16                   <li><a href="http://www.oracle.com/">Oracle</a>
  17                   <li><a href="http://www.borland.com/products/downloads/download_interbase.html">Interbase</a>
  18                   <li><a href="http://www.sybase.com/downloads">Sybase</a> and
  19                   <a href="http://www.microsoft.com/sql/default.asp">Microsoft SQL Server</a> (
  20                   via <a href="http://www.freetds.org/">FreeTDS</a>)
  21                   <li><a href="http://www-3.ibm.com/software/data/db2/">IBM DB2 Universal Database</a>
  22                   <li><a href="http://www.hwaci.com/sw/sqlite/download.html">SQL Lite</a>
  23                   <li><a href="http://www.microsoft.com/office/access/default.asp">MS Access</a>
  24                   (via <a href="http://mdbtools.sourceforge.net/">MDB Tools</a>)
  25         </ul>
  26 </ul>
  27
  28 * Current Status
  29         <ul>
  30                 <li>The OleDb provider is working with libgda (an OLE-DB/ADO data access for Unix).
  31                 The C-Sharp bindings to libgda currently work - meaning they can compile, run,
  32                 and you can connect to a
  33                 PostgreSQL database via libgda via the C-Sharp bindings to libgda.
  34
  35                 <li>Basic
  36                 functionality (execution of commands, data retrieval, transactions, etc) are
  37                 now working.
  38
  39                 <li>An inital implementation of GetSchemaTable() for
  40                 the OleDbDataReader has been checked into cvs.  GetSchemaTable() isn't correct for OleDb,
  41                 but the foundation is there.
  42         </ul>
  43
  44 * Action Plan
  45         <ul>
  46                 <li>Current focus is on filling up the missing pieces (Data adapters
  47                 mainly) and schema support.
  48
  49                 <li>We need help building libgda on Windows though.  libgda
  50                 builds find on linux though.
  51
  52                 <li>Need to make the OleDb provider compatible with the OleDb provider in Microsoft .NET
  53         </ul>