[Mono-list] System.Data.OleDb (via libgda) is able to read data

Rodrigo Moya rodrigo@ximian.com
16 Aug 2002 04:37:16 +0200


--=-w5EPbNQ1S5QYh+qi8m7+
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Hi

I just committed code to mono cvs that allows to read data via libgda in
System.Data.OleDb Mono implementation.

To test it, you just need to install libgda (with postgres support
compiled in), create a data source for libgda (see the attached file,
which should be saved as ~/.libgda/config), and compile and run the
TestOleDb program in System.Data.OleDb/TestOleDb.cs.

It is still rudimentary, but supports reading data models (recordsets)
returned by libgda functions.

The config file is to connect to a local postgres database. libgda
supports other DBMS, so if you want to connect to another database
supported by libgda, you'll just have to tweak the config file.

cheers
-- 
Rodrigo Moya <rodrigo@ximian.com>

--=-w5EPbNQ1S5QYh+qi8m7+
Content-Disposition: attachment; filename=config
Content-Type: text/plain; name=config; charset=ISO-8859-15
Content-Transfer-Encoding: 7bit

<?xml version="1.0"?>
<libgda-config>
  <section path="/apps/libgda/Datasources/PostgreSQL">
    <entry name="Provider" type="string" value="PostgreSQL"/>
    <entry name="DSN" type="string" value="DATABASE=template1;HOST=localhost"/>
    <entry name="Description" type="string" value="System database in PostgreSQL"/>
    <entry name="Username" type="string" value="rodrigo"/>
    <entry name="Password" type="string" value=""/>
  </section>
</libgda-config>
--=-w5EPbNQ1S5QYh+qi8m7+--