[IronPython] example of using IronPython with MS Access database (.mdb)?
cenovsky at bakalari.cz
Mon May 24 09:49:15 PDT 2010
Peter Masiar wrote:
> 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
> 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.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Users