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