[DB-SIG] DCOracle2 install help.

[Matthew T. Kromer]

Titu Kim wrote:

>Hi Matthew and all,
>   Your reply triggers an idea for me. I make a
>symbolic link from /usr/bin/python to
>/usr/local/bin/python and then rebuitd the binaries.
>Then i copy the whole DCOracle2 directory to
>/usr/local/lib/python2.1/DCOracle2. It works.
>Everything works fine now.I can do db connection and
>make queries to db and retrieve result using fetch**.
>This works perfectly in interactive mode or in a
>separate file. However, when i port the same program
>to cgi-bin, i get error when trying to establish a
>connection. Apache gives this error
>""""""""
>Traceback(most recent call last):
>   File "/var/www/cgi-bin/mycgi.cgi" line 6, in ?
>        conn = DCOracle2.py", line 116 in connect
>  dco2.DatabaseError:(12154, 'Error while trying to
>retrieve text for error ORA-12154')
>Premature end of script
>headers:/var/www/cgi-bin/mycgi.cgi
>
>""""""""""""""
>Why the standalone program work fine but does not work
>with cgi? Do you have any comment? Thanks a lot.
>
>Kim Titu
>

When it cannot retreive the error message text, that means "I don't have 
ORACLE_HOME" set -- set your ORACLE_HOME environment for your web server.

>