Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Python > Python 3.1 cx_Oracle 5.0.2 "ImportError: DLL load failed: Thespecified module could not be found."

Reply
Thread Tools

Python 3.1 cx_Oracle 5.0.2 "ImportError: DLL load failed: Thespecified module could not be found."

 
 
André
Guest
Posts: n/a
 
      11-19-2009
Hello,

I'm trying to get Python 3.1 and cx_Oracle 5.02
(cx_Oracle-5.0.2-10g.win32-py3.0.msi) to connect to an Oracle
11.1.0.7.0 database via OraClient10g 10.2.0.3.0 with Pydev
1.5.1.1258496115 in Eclipse 20090920-1017 on Windows XP SP 3 v2002.
The import cx_Oracle line appears as an unresolved import and when I
run the application I get the following error to console:
Traceback (most recent call last):
File "FILEPATHHERE", line 1, in <module>
import cx_Oracle
ImportError: DLL load failed: The specified module could not be found.

Apparently the error is caused by cx_Oracle not being able to find the
Oracle client DLLs (oci.dll and others). The client home path and the
client home path bin directory are in the PATH System Variable and
oci.dll is there.

I tried getting the Oracle Instant Client (instantclient-basic-
win32-11.1.0.7.0.zip from http://www.oracle.com/technology/sof...s/winsoft.html)
and installing it as directed. I added the instant client path to the
PATH System Variable but that didn't work either.

I have scoured the internet and have not found a solution.

Please help!
 
Reply With Quote
 
 
 
 
Neil Hodgson
Guest
Posts: n/a
 
      11-19-2009
André:

> Apparently the error is caused by cx_Oracle not being able to find the
> Oracle client DLLs (oci.dll and others). The client home path and the
> client home path bin directory are in the PATH System Variable and
> oci.dll is there.


Open the cx_Oracle extension with Dependency Walker
(http://www.dependencywalker.com/) to get a better idea about what the
problem is in more detail.

Neil
 
Reply With Quote
 
 
 
 
André
Guest
Posts: n/a
 
      11-26-2009
On Nov 19, 6:57*pm, Neil Hodgson <(E-Mail Removed)>
wrote:
> André:
>
> > Apparently the error is caused by cx_Oracle not being able to find the
> > Oracle client DLLs (oci.dll and others). The client home path and the
> > client home path bin directory are in the PATH System Variable and
> > oci.dll is there.

>
> * *Open the cx_Oracle extension with Dependency Walker
> (http://www.dependencywalker.com/) to get a better idea about what the
> problem is in more detail.
>
> * *Neil


Thanks Neil. I used Dependency Walker and discovered cx_Oracle was
looking for python30.dll. I seems to be a known issue with Python 3.1
http://bugs.python.org/issue4091. I'm now used Python 2.6.4 and the
corresponding cx_Oracle version with no problems.

Thanks for the help
 
Reply With Quote
 
Dennis Lee Bieber
Guest
Posts: n/a
 
      11-26-2009
On Wed, 25 Nov 2009 16:32:36 -0800 (PST), André
<(E-Mail Removed)> declaimed the following in
gmane.comp.python.general:


>
> Thanks Neil. I used Dependency Walker and discovered cx_Oracle was
> looking for python30.dll. I seems to be a known issue with Python 3.1
> http://bugs.python.org/issue4091. I'm now used Python 2.6.4 and the
> corresponding cx_Oracle version with no problems.
>

That bug doesn't sound all that much like your problem...

From the original post

op>
op> I'm trying to get Python 3.1 and cx_Oracle 5.02
op> (cx_Oracle-5.0.2-10g.win32-py3.0.msi) to connect to an Oracle

Notice: You claim to be using Python 3.1 yet installing a cx_Oracle
package built (linking against) Python 3.0...

Which is just what you have discovered -- it was looking for a
Python DLL you didn't have installed.
--
Wulfraed Dennis Lee Bieber KD6MOG
http://www.velocityreviews.com/forums/(E-Mail Removed) HTTP://wlfraed.home.netcom.com/

 
Reply With Quote
 
thompjs
Guest
Posts: n/a
 
      01-24-2011

I'm having similar issue but everything seems to be installed in correct
places.

Loaded "CX_ORACLE.PYD" at address 0x6BD80000. Successfully hooked module.
Loaded "OCI.DLL" at address 0x10000000. Successfully hooked module.
Unloaded "CX_ORACLE.PYD" at address 0x6BD80000.
Unloaded "OCI.DLL" at address 0x10000000.
LoadLibraryExA("C:\JSTData\Python27\lib\site-packages\cx_Oracle.pyd",
0x00000000, LOAD_WITH_ALTERED_SEARCH_PATH) returned NULL. Error: The
specified procedure could not be found (127).

Why is cx_Oracle not found after it has been hooked?

Thanks to anyone that can shed some light on this.
--
View this message in context: http://old.nabble.com/Python-3.1-cx_...p30748079.html
Sent from the Python - python-list mailing list archive at Nabble.com.

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ImportError: DLL load failed: The specified module could not be found, SWIG, life, etc Bill Davy Python 3 07-27-2011 12:47 PM
cx_Oracle - DLL load failed cwurld Python 1 04-13-2009 06:26 PM
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/DynaLoader.pm line 230. Feyruz Perl Misc 4 10-14-2005 06:47 PM
cx_Oracle failed to load DLL BUT versions correct jmdeschamps Python 1 02-09-2005 03:55 PM
Error Message: Outlook Express Could Not Be Started Because Msoe.dll Could Not Be Loaded Dutch Treat Computer Support 4 06-21-2004 02:01 PM



Advertisments