Accessing Oracle from Python

[M.-A. Lemburg]

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:

	http://www.sqlsummit.com/ODBCVend.htm

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

	http://fndapl.fnal.gov/~dbox/oracle/odbc/

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
eGenix.com

Professional Python Services directly from the Source  (#1, Jul 16 2004)
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

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