[cx-oracle-users] Oracle instant client / Solaris / connecting to 9i database

[Hubert B H. <hhi...@un...>]

I have compiled cx_oracle 4.1.2 for Solaris 8 using the Oracle 10g instant 
client.  I had to do a bit of changing in the setup.py file to specify the 
correct include and library paths. 

When I try to connect to an Oracle 9i database, I get the following error:

  File "/export/home0/hhickman_testing/work/ResultsByOrder/ResultsDb.py", 
line 9, in ?
    import cx_Oracle
ImportError: ld.so.1: python: fatal: libclntsh.so.9.0: open failed: No 
such file or directory

If I do a symbolic link to link the 10.0 libclntsh to the 9.0 version, 
then my program (mostly) works, but I eventually get to the following 
problem.
TypeError: can't compare datetime.datetime to cx_Oracle.Timestamp

This same program works 
I can download and install the correct 9i client and build cx_Oracle that 
way, but it would be nice to get this going with the instant client!

Thanks!

Hubert B. Hickman

Email : hhi...@un...