[IronPython] example of using IronPython with MS Access database (.mdb)?

[Peter Masiar]

Thank you. The three lines from Oracle example made the difference:

import clr
import System
clr.AddReference("System.Data")

Of course they are obvious for you gurus but to help a confused
learner like me, it would be nice to add them to main ODBC example at
http://www.ironpython.info/index.php/Databases_with_Odbc

"helping the next guy" (TM)

On Mon, May 24, 2010 at 12:49 PM, Lukas Cenovsky <cenovsky at bakalari.cz> wrote:
> Peter Masiar wrote:
>
> Gurus,
>
> I am trying to wrap my mind about how I can access MS Access database
> from IronPython. My apologies - I bet this was asked about zillion
> times, but of course "Access" is impossible to google. I believe that
> it is same thing as Jet engine, Access 2003 uses .mdb as file
> extension.
>
> I found http://www.ironpython.info/index.php/Databases_with_Odbc but
> AFAICT it uses MS SQL server.
> IronPython in Action book uses PostgreSQL. There are plenty of MySQL
> and SQLite examples, but I am stuck with Access (and want to get out -
> IronPython should be first step).
>
> I would also prefer stock IronPython install - I expect there should
> be a way to work with Access databases, right? Unless some other
> library provides much better functionality.
>
> Should be something trivial but I am confused. Any links to simple examples?
>
> Thank you
>
> I would check System.Data.OleDb namespace. I use it for working with FoxPro
> .dbf files (via vfpoledb.dll) and I think there must be driver for Access
> too.
>
> --
> -- Lukáš
>
> _______________________________________________
> Users mailing list
> Users at lists.ironpython.com
> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
>
>



-- 
-----
Peter Masiar