Re: [cx-oracle-users] DLL load failed
Brought to you by:
atuining
Menu
▾
▴
Re: [cx-oracle-users] DLL load failed
|
From: Dominique D. <dom...@to...> - 2017-04-14 16:03:54
|
I have cx_Oracle operational on my machine. The only remaining action was to set PATH via control panel as shown in the web page you indicated, instead of DOS which apparently does not keep the changes (I may have limited admin rights). Thank you very much for your support. Dominique From: Anthony Tuininga [mailto:ant...@gm...] Sent: vendredi 14 avril 2017 17:03 To: cx-...@li... Subject: Re: [cx-oracle-users] DLL load failed Yes, installing Instant Client 12 will work for you. However, do not set ORACLE_HOME. On Windows you should simply put the location of OCI.DLL in your PATH environment variable. And in your case, ensure that it is before your other Oracle installation. This link gives the information on which Oracle client and server combinations are supported. It is part of the ODPI-C library which will be the underlying library used as of cx_Oracle 6. https://oracle.github.io/odpi/doc/installation.html#oracle-client-and-database-versions Anthony On Fri, Apr 14, 2017 at 1:48 AM, Dominique DEXHEIMER <dom...@to...<mailto:dom...@to...>> wrote: 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...<mailto:ch...@gh...>] Sent: jeudi 13 avril 2017 18:26 To: cx-...@li...<mailto: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 ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ cx-oracle-users mailing list cx-...@li...<mailto:cx-...@li...> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users |
