On 05/01/2011 16:33, F1r3f1y wrote:
This guide helped me a lot with cx_Oracle
http://codingtutorials.co.uk/blog/?p=31
Greg Lindstrom-3 wrote:
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
You need to install the Runtime, 3rd product option in the Oracle
Universal Installer.
--
Kind Regards,
Christian Witts
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor