[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