Accessing Oracle from Python

[Larry Bates]

You don't want to use ODBC as that is a Windows interface
that doesn't natively exist on Linux.  You can purchase
Linux ODBC interfaces from companies like EasySoft, but
if your program is running on Linux you will be much better
off with a native interface.  ODBC overhead is quite large
and should be avoided whenever possible.  You didn't say
which version of Oracle, but for 7 and 8 you can use

http://www.zope.org/Products/DCOracle/

8i and above can be accessed using

http://www.zope.org/Members/matt/dco2/

Access to remote Oracle databases is just done via TCP
connections.

Note: Our experience is that Oracle runs MUCH better
on Linux than Windows (as much as 5 times faster on
equivalent hardware).  Are you sure you want the database
on Windows?

HTH,
Larry Bates
Syscon, Inc.

"Dan Ellis" <usenet at electricwords.org> wrote in message
news:bf9b9a98.0407150751.1ffa218b at posting.google.com...
> 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?
>
> Thanks,
> Dan.
>
> -- 
> Dan Ellis, Computer Officer
> North Lindsey College