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
>
>
--
View this message in context:
http://old.nabble.com/cx_Oracle-help-tp15293236p30596546.html
Sent from the Python - tutor mailing list archive at Nabble.com.
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor
