cx_oracle and python 2.7
cx-oracle, python, python-2.7
Solution
I was able to solve this problem with the following steps:
Download instantclient-basic-win32-10.2.0.5 from Oracle Website
unzipped the into my c:\ with the name oraclient
Created the directory structure C:\oraclient\network\admin to add the TNSNAMES.ORA
Added the TNS_ADMIN env var pointing to C:\oraclient\network\admin
Added the ORACLE_HOME env var pointing to C:\oraclient\
After that i used the following code:
import cx_Oracle
con = cx_Oracle.connect('theuser', 'thepass', 'your DB alias on your TNSNAMES.ORA file ')
cur = con.cursor()
if cur.execute('select * from dual'):
print "finally, it works!!!"
else:
print "facepalm"
con.close()
I hope it helps someone.
Problem
Im using python 2.7 and cx_oracle ( Windows x86 Installer (Oracle 10g, Python 2.7) ) and 'm having a bad time to set this simple example bellow to work: ``` import cx_Oracle connection = cx_Oracle.connect('user/pass@someserver:port') cursor = connection.cursor() cursor.execute('select sysdate from dual') for row in cursor: print row connection.close() ``` Error Message: ``` Traceback (most recent call last): File "C:\ORACON.py", line 1, in <module> import cx_Oracle ImportError: DLL load failed: The specified module could not be found. ``` For now, what i have done was: 1) installed the cx_oracle binary; 2) downloaded instantclient_10_2 from oracle website and exported the path to environment; Anyone know what im missing? Thank you for your time on reading this.