Python and Oracle 9i

Gerhard Häring gerhard at bigfoot.de
Mon Feb 25 14:54:31 EST 2002


Gerhard Häring wrote in comp.lang.python:
> 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.

Oops. I meant it could be a possible solution for your Oracle
troubles, and it does run on Linux and Windows.

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')))



More information about the Python-list mailing list