Thread: Re: [cx-oracle-users] Version 5.1 vs 5.04
Brought to you by:
atuining
Menu
▾
▴
cx-oracle-users
|
From: Gerrat R. <gri...@co...> - 2011-04-14 16:48:02
|
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 >> >> >> >> >> > |
|
From: Anthony T. <ant...@gm...> - 2011-04-14 17:33:37
|
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 > > |
|
From: Gerrat R. <gri...@co...> - 2011-04-14 18:59:42
|
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 |
|
From: Jim T. <jim...@ls...> - 2011-04-14 21:45:34
|
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 |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X