SQL-Statement with Python

[ccang]

Servus,
I have a Jpython script which accesses a mdb database.
It uses jdbc.
See http://www.ozemail.com.au/~calcium/scripts.html

I'm pretty sure there is an ODBC thing for Python.
Would look it up for u but I'm tired.

Ciao,
Chai
http://www.ozemail.com.au/~calcium

Juergen Hofer wrote:

> Hi to all!
>
> Is it possible to connect to a M$-Access Database (*.mdb) with
Python
> and make simple SQL-Queries and import the results into a list?
> I'm using Python2.0 under Windows98.
>
> Thanks
> Jürgen



Simon Brunning wrote:

> > From: Juergen Hofer [SMTP:juergen.hofer at students.uni-linz.ac.at]
> > Is it possible to connect to a M$-Access Database (*.mdb) with Python
> > and make simple SQL-Queries and import the results into a list?
> > I'm using Python2.0 under Windows98.
>
> Try mxODBC, from <http://www.lemburg.com/files/python/>. Don't forget to
> read the licence - there are restrictions.
>
> Cheers,
> Simon Brunning
> TriSystems Ltd.
> sbrunning at trisystems.co.uk
>
> -----------------------------------------------------------------------
> The information in this email is confidential and may be legally privileged.
> It is intended solely for the addressee. Access to this email by anyone else
> is unauthorised. If you are not the intended recipient, any disclosure,
> copying, distribution, or any action taken or omitted to be taken in
> reliance on it, is prohibited and may be unlawful. TriSystems Ltd. cannot
> accept liability for statements made which are clearly the senders own.

--
| mailto:calcium at ozemail.com.au   | +61 401 688 408
| My mother never saw the irony in calling me a son-of-a-bitch -Rich Jeni