Re: [cx-oracle-users] Version 5.1 vs 5.04

[Jim T. <jim...@ls...>]

I had similar issue.  I'm not sure how I fixed it though.

Can you try running InstantClient for 10.2?

I think Oracle 11 messes with .dll search order from what I understand.

If I recover my thoughts on what I did awhile back I'll let you and the 
list know.

On 4/14/2011 2:01 PM, Gerrat Rickert wrote:
> Thanks for the suggestion, Anthony.
> Nothing at all about it in the event log.
>
> I just found this: http://bugs.python.org/issue10854 and really wish they had decided to "re-implement depends.exe" in python ;)
>
> I tried running depends.exe via subprocess at the point where I would have imported cx_Oracle, but the output was the same as just running it from the command prompt (same error messages with both versions).
> I guess doing this isn't the same as importing it via python.
>
>
> Gerrat
>
>
> -----Original Message-----
> From: Anthony Tuininga [mailto:ant...@gm...]
> Sent: April 14, 2011 1:34 PM
> To: cx-...@li...
> Subject: Re: [cx-oracle-users] Version 5.1 vs 5.04
>
> You're welcome.
>
> One other thing: check the event log. There might be a "side-by-side"
> error that is taking place.
>
> Anthony
>
> On Thu, Apr 14, 2011 at 10:49 AM, Gerrat Rickert
> <gri...@co...>  wrote:
>> Thanks for the response, Anthony.
>>
>> I don't know how to go about finding which DLL it's complaining about - it
>> doesn't write that information to the error logs.
>>
>> I tried running Dependency Walker on cx_Oracle.pyd (not even sure if this is
>> correct/useful at all, but wanted to at least try *something*).
>>
>> It came back with an error message, and couldn't open: (MSVCR90.DLL,
>> IESHIMS.DLL, and WER.DLL), but I get the same error messages on the 5.04
>> (working) version as well.
>>
>>
>>
>> Regards,
>>
>>    Gerrat
>>
>>
>>
>>> Which DLL is it complaining about? Its possible that it is not found
>>> in the web environment but is found in the command line environment. I
>>> started compiling with the MSVC compiler for cx_Oracle 5.1 which might
>>> make a difference in how the linking took place. If you find out which
>>> DLL it is I can look more carefully into that.
>>> Anthony
>>> On Tue, Apr 12, 2011 at 11:27 AM, Gerrat Rickert
>>> <grickert@...>  wrote:
>>>> I had the windows version of cx_Oracle 5.04 for Oracle 11g for python 2.7
>>>> installed, and it worked fine (cx_Oracle-5.0.4-11g.win32-py2.7.msi).
>>>> It worked on an intranet web application as well as just at a command
>>>> prompt.
>>>> I upgraded to the 5.1 version (cx_Oracle-5.1-11g.win32-py2.7.msi) , and I
>>>> now get the message:
>>>> ImportError: DLL load failed: The specified module could not be found.
>>>> in my apache error logs when my web app tries importing cx_Oracle.
>>>> Nothing else has changed.
>>>> I'm using an Oracle 11g client (and connecting to an Oracle 11g
>>>> database).
>>>> The latest version (5.1) works fine from a command prompt, but not from
>>>> the
>>>> (Werkzeug) web application.
>>>> When I uninstalled it, and reinstalled the 5.04 version, everything works
>>>> again.
>>>> I don't really *need* to upgrade, but thought I might as well be using
>>>> the
>>>> latest version.
>>>> Anyone have any thoughts on why this doesn't work now?
>>>> Do I need to do something extra with this version that wasn't required
>>>> with
>>>> the previous?
>>>> Regards,
>>>>                   Gerrat
>> ------------------------------------------------------------------------------
>> Benefiting from Server Virtualization: Beyond Initial Workload
>> Consolidation -- Increasing the use of server virtualization is a top
>> priority.Virtualization can reduce costs, simplify management, and improve
>> application availability and disaster protection. Learn more about boosting
>> the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>>
> ------------------------------------------------------------------------------
> Benefiting from Server Virtualization: Beyond Initial Workload
> Consolidation -- Increasing the use of server virtualization is a top
> priority.Virtualization can reduce costs, simplify management, and improve
> application availability and disaster protection. Learn more about boosting
> the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
> ------------------------------------------------------------------------------
> Benefiting from Server Virtualization: Beyond Initial Workload
> Consolidation -- Increasing the use of server virtualization is a top
> priority.Virtualization can reduce costs, simplify management, and improve
> application availability and disaster protection. Learn more about boosting
> the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

-- 
Jim Thompson

Reply To: ji...@ls...

LSF Development Corp.     Jim Thompson
PO Box 201                6311 Ski Texas Lane	
Martindale, TX  78655     Rosharon, TX 77583

832 423 7428 (mobile - ATT)
775 264 6670 (e-fax)

http://www.lsfdev.com
http://www.SanMarcosRiverRanch.com