[Tutor] cx_Oracle help

[Greg Lindstrom]

Hello,

I'm trying to help out a friend and am stumped.  Can you help me out?
Thanks,
--greg

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
     I will briefly explain the problem I am facing.
     I am using Oracle 9.2, Python 2.5 and I installed cx_Oracle-
4.3.1-win32-9i-py25 in Python.

     From python I tried following :
     >>> import cx_Oracle
     >>> myDsn = cx_Oracle.makedsn('ISCN47',1521,'AUBDBS01')
     >>> CONN = cx_Oracle.connect(myusr, mypwd, myDsn)
                    Traceback (most recent call last):
                    File "<pyshell#4>", line 1, in <module>
                   conn = cx_Oracle.Connection('scott','tiger',myDsn)
                   RuntimeError: Unable to acquire Oracle environment handle

     I have set the below environment variables too
          NLS_LANG:              <snip>.WE8MSWIN1252
          ORACLE_HOME:        D:\Tools\oracle\ora92
          ORACLE_SID:           AUBDBS01
          PYTHON_HOME:        d:\Utility\Python25
          PYTHONPATH:
%PYTHON_HOME%\lib;%PYTHON_HOME%\DLLs;%PYTHON_HOME%\Lib\site-packages;%ORACLE_HOME%\bin
          LD_LIBRARY_PATH:   %LD_LIBRARY_PATH%;D:\Tools\oracle\ora92\lib

     Not getting any idea where I am wrong?

Regards,

Kishore
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/tutor/attachments/20080205/a910d398/attachment-0001.htm