[Tutor] cx_Oracle help

[Christian Witts]

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