[Tutor] cx_Oracle help

[F1r3f1y]

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 at 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.