Accessing Oracle from Python

M.-A. Lemburg mal at
Fri Jul 16 18:10:14 CEST 2004

Dan Ellis wrote:
> Hi,
> I've been down so many dead ends trying to get something working, so
> I'm really hoping someone can help out.
> I need to access an Oracle database running on a Windows server from
> Python running on Linux. I've tried building DCOracle2, but it seems
> that the 'oracle-installclient-basic' thing I downloaded from the
> Oracle site doesn't contain enough. I've tried various other
> approaches, such as mxODBC/iODBC, but without much luck. I'm hoping to
> not have to resort to a Windows solution.
> Can someone help me figure out what combination of Python module,
> Oracle download and/or ODBC driver will work?

The EasySoft Oracle drivers works nicely with mxODBC/unixODBC.
Other vendors of ODBC drivers for Oracle are: DataDirect,
OpenLink and a few others:

There's also an open-soruce Oracle ODBC driver:

Naturally, the EasySoft driver works best with unixODBC and
the OpenLink one with iODBC (simply because those two companies
took over development of these ODBC managers).

Marc-Andre Lemburg

Professional Python Services directly from the Source  (#1, Jul 16 2004)
 >>> Python/Zope Consulting and Support ...
 >>> mxODBC.Zope.Database.Adapter ...   
 >>> mxODBC, mxDateTime, mxTextTools ...

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::

More information about the Python-list mailing list