cx-oracle-users

[cx-oracle-users] cx_Oracle cannot be loaded by PyISAPIe on IIS

[Brian B. <Bri...@st...>]

Hi,

I have a coworker that has developed a Django application, and I am
trying to get it to run under IIS on Windows Server 2008 R2. I'm
generally following the Django walkthrough [1] although not with SQL
Server.

If I run python from the command prompt and import cx_Oracle, it works
just fine. However, when the Django application is loaded by IIS and
PyISAPIe, it says it cannot load cx_Oracle and displays the following
error:

Error loading cx_Oracle module: DLL load failed: The specified module
could not be found.

I've used Process Monitor to watch what happens, and it seems to be some
oddity with loading the VC runtime. Python loads msvcr80.dll
successfully. PyISAPIe attempts to load msvcr90.dll but is unable to
find it -- it doesn't try using msvcr80.dll at all.

I'm using the 32-bit versions of the following:

Python 2.6.6
PyISAPIe 1.1.0 rc4
Django 1.3
Oracle Client 11.2 (I've tried both the instant client and the regular
client)
cx_Oracle 5.1 (for Oracle 11g, Python 2.6)

Any thoughts on why this might be happening?

[1]
https://code.djangoproject.com/wiki/DjangoOnWindowsWithIISAndSQLServer

Brian Baker

Re: [cx-oracle-users] cx_Oracle cannot be loaded by PyISAPIe on IIS

[Anthony T. <ant...@gm...>]

Hi,

Only a guess but perhaps you can install the Microsoft Visual Studio
2008 redistributable package for your platform. The Python executable
has that as a private assembly I believe but you will need to make it
available generally if it isn't already. And the error message
suggests that it is not.

Or you could just make life a lot easier for yourself (maybe) by using
Apache. :-) It installs and runs very easily indeed on Windows. I had
one machine that worked perfectly with IIS and another one where it
simply did not work at all -- and no error messages or other helpful
information available. Just crash. So I decided to use Apache and
everything worked in short order thanks to a decent logging system
that showed me my errors when I made them. YMMV of course. :-)

Anthony

On Thu, Jun 23, 2011 at 11:33 AM, Brian Baker <Bri...@st...> wrote:
> Hi,
>
> I have a coworker that has developed a Django application, and I am
> trying to get it to run under IIS on Windows Server 2008 R2. I'm
> generally following the Django walkthrough [1] although not with SQL
> Server.
>
> If I run python from the command prompt and import cx_Oracle, it works
> just fine. However, when the Django application is loaded by IIS and
> PyISAPIe, it says it cannot load cx_Oracle and displays the following
> error:
>
> Error loading cx_Oracle module: DLL load failed: The specified module
> could not be found.
>
> I've used Process Monitor to watch what happens, and it seems to be some
> oddity with loading the VC runtime. Python loads msvcr80.dll
> successfully. PyISAPIe attempts to load msvcr90.dll but is unable to
> find it -- it doesn't try using msvcr80.dll at all.
>
> I'm using the 32-bit versions of the following:
>
> Python 2.6.6
> PyISAPIe 1.1.0 rc4
> Django 1.3
> Oracle Client 11.2 (I've tried both the instant client and the regular
> client)
> cx_Oracle 5.1 (for Oracle 11g, Python 2.6)
>
> Any thoughts on why this might be happening?
>
> [1]
> https://code.djangoproject.com/wiki/DjangoOnWindowsWithIISAndSQLServer
>
> Brian Baker
>
> ------------------------------------------------------------------------------
> Simplify data backup and recovery for your virtual environment with vRanger.
> Installation's a snap, and flexible recovery options mean your data is safe,
> secure and there when you need it. Data protection magic?
> Nope - It's vRanger. Get your free trial download today.
> http://p.sf.net/sfu/quest-sfdev2dev
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] cx_Oracle cannot be loaded by PyISAPIe on IIS

[Brian B. <Bri...@st...>]

I have tried installing both the Visual C++ 2005 (version 8) and 2008
(version 9) redistributables, but that didn't seem to make a difference,
unfortunately.

Brian

-----Original Message-----
From: Anthony Tuininga [mailto:ant...@gm...] 
Sent: Thursday, June 23, 2011 11:40 AM
To: cx-...@li...
Subject: Re: [cx-oracle-users] cx_Oracle cannot be loaded by PyISAPIe on
IIS

Hi,

Only a guess but perhaps you can install the Microsoft Visual Studio
2008 redistributable package for your platform. The Python executable
has that as a private assembly I believe but you will need to make it
available generally if it isn't already. And the error message suggests
that it is not.

Or you could just make life a lot easier for yourself (maybe) by using
Apache. :-) It installs and runs very easily indeed on Windows. I had
one machine that worked perfectly with IIS and another one where it
simply did not work at all -- and no error messages or other helpful
information available. Just crash. So I decided to use Apache and
everything worked in short order thanks to a decent logging system that
showed me my errors when I made them. YMMV of course. :-)

Anthony

On Thu, Jun 23, 2011 at 11:33 AM, Brian Baker
<Bri...@st...> wrote:
> Hi,
>
> I have a coworker that has developed a Django application, and I am 
> trying to get it to run under IIS on Windows Server 2008 R2. I'm 
> generally following the Django walkthrough [1] although not with SQL 
> Server.
>
> If I run python from the command prompt and import cx_Oracle, it works

> just fine. However, when the Django application is loaded by IIS and 
> PyISAPIe, it says it cannot load cx_Oracle and displays the following
> error:
>
> Error loading cx_Oracle module: DLL load failed: The specified module 
> could not be found.
>
> I've used Process Monitor to watch what happens, and it seems to be 
> some oddity with loading the VC runtime. Python loads msvcr80.dll 
> successfully. PyISAPIe attempts to load msvcr90.dll but is unable to 
> find it -- it doesn't try using msvcr80.dll at all.
>
> I'm using the 32-bit versions of the following:
>
> Python 2.6.6
> PyISAPIe 1.1.0 rc4
> Django 1.3
> Oracle Client 11.2 (I've tried both the instant client and the regular
> client)
> cx_Oracle 5.1 (for Oracle 11g, Python 2.6)
>
> Any thoughts on why this might be happening?
>
> [1]
> https://code.djangoproject.com/wiki/DjangoOnWindowsWithIISAndSQLServer
>
> Brian Baker

Re: [cx-oracle-users] cx_Oracle cannot be loaded by PyISAPIe on IIS

[Amaury F. d'A. <ama...@gm...>]

Hi,

2011/6/23 Brian Baker <Bri...@st...>:
> Python loads msvcr80.dll

Is it a custom build of Python?
"official" python distributions use vs9.0; older ones used vs7.0.
but python.org has never distributed binaries built with vs8.0.

In any case, cx_Oracle should be compiled with the same version.

-- 
Amaury Forgeot d'Arc

Re: [cx-oracle-users] cx_Oracle cannot be loaded by PyISAPIe on IIS

[Brian B. <Bri...@st...>]

Amaury Forgeot d'Arc [mailto:ama...@gm...] wrote:
> Is it a custom build of Python?

No, I'm using official binary builds of both Python 2.6.6 and cx_Oracle
5.1 (the MSI packages).

Brian

Re: [cx-oracle-users] cx_Oracle cannot be loaded by PyISAPIe on IIS

[Brian B. <Bri...@st...>]

So, for anyone tracking this, I ended up installing cx_Oracle 4.4.1
which worked just fine. Not sure the difference between that and 5.1,
but it seems to be working fine for our application.

Thanks for your assistance.

Brian