Python and Oracle 9i

[Gerhard Häring]

Bob Lancaster wrote in comp.lang.python:
> I am in a bit of a quandry. 
> I am writing a python module which converts some data from various
> python variables, lists, etc. into SQL, which in turn is inserted to
> or selected from a database.
> 
> I need to support three combinations.
> (1) PostgreSQL and Linux, for academic customers.  No serious problems
> here.  In fact, I have learned why folks love PostgreSQL so much.
> 
> (2) Oracle 9i and Linux.  I haven't tried this one yet, but it seems
> to be at least as easy as the third combination.
> 
> (3) Oracle 9i and Windows 2000, for industrial customers.  Trouble!
> I have tried two approaches.  
>   (a) DCOracle2:  builds, connects, but then does not work properly. 
> I see two possible sources of the problem.

Or:

(4) Use a commercially supported DB module like mxODBC.

Gerhard
-- 
mail:   gerhard <at> bigfoot <dot> de       registered Linux user #64239
web:    http://www.cs.fhm.edu/~ifw00065/    OpenPGP public key id 86AB43C0
public key fingerprint: DEC1 1D02 5743 1159 CD20  A4B6 7B22 6575 86AB 43C0
reduce(lambda x,y:x+y,map(lambda x:chr(ord(x)^42),tuple('zS^BED\nX_FOY\x0b')))