Re: [cx-oracle-users] DLL load failed

[Dominique D. <dom...@to...>]

dependencywalker helped pinpoint the sore muscle, which is finding OCI.DLL. However it may just be a back compatibility issue. I have Oracle Client 10.2 while the oldest version of cx_Oracle is 11g.  I looked up previous posts for compatibility issues, but could not find anything helpful.

My best bet is to install Instant Client 12 and give it precedence over the other client installed by pointing ORACLE_HOME to it.

Thanks and regards,
Dominique

From: Massa, Harald Armin [mailto:ch...@gh...]
Sent: jeudi 13 avril 2017 18:26
To: cx-...@li...
Subject: Re: [cx-oracle-users] DLL load failed

Hi,

I have run the installer cx_Oracle-5.2.1-12c.win-amd64-py2.7.exe on a Dell Precision T5610, running Windows7 64 bits, with apparent success: the compiled file cx_Oracle.pyd is in place under the site-packages directory. However, it seems that Python misses parts of the module (see session  below), even after appending a line to sys.path. Would there be another module registration to write somewhere before running it ?

>>> import cx_Oracle

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

most likely you are missing the Oracle OCI libary in the fitting 12c version. They have to be downloaded and licenced with Oracle.

Make sure cx_Oracle is able to find them, usefull things are:
- have the bin directory in your path
- have the oracle environment variables set correctly.

Usefull tool to diagnose:
http://www.dependencywalker.com/

Cheers,

Harald




--

GHUM GmbH
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607

Amtsgericht Stuttgart, HRB 734971