How can I access Oracle from Python?

Question

How can I access Oracle from Python? I have downloaded a cx_Oracle mis but Python can't import the library.

I get the following error

import cx_Oracle

Traceback (most recent call last): File "", line 1, in import cx_Oracle ImportError: DLL load failed: The specified module could not be found.

I will be grateful for any help

Answer 1

In addition to cx_Oracle, you need to have the Oracle client library installed and the paths set correctly in order for cx_Oracle to find it - try opening the cx_Oracle DLL in "Dependency Walker" (http://www.dependencywalker.com/) to see what the missing DLL is.