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
>