python cx_oracle底层是什么,cx_oracle和python 2.7

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

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.

解决方案

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.