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
_______________________________________________
Tutor maillist - Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor
