[cx-oracle-users] Lack of cx_oracle.pyd

[Joe H. <jwh...@me...>]

All,

	I've been fighting this for a couple of days.  I used the msi install on the CX Oracle page and the installer doesn't install something since when I do an import cx_oracle I get the below.

$ python
ActivePython 3.2.2.3 (ActiveState Software Inc.) based on
Python 3.2.2 (default, Sep  8 2011, 10:56:38) [MSC v.1500 32 bit (Intel)] on win
32
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_oracle
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ImportError: No module named cx_oracle

 I downloaded Lessmsi and don't see the file in there.  Is it missing?  Here is what I posted on Stackoverflow

I downloaded Windows X86 Installer (Oracle 10g, Python 3.2) from http://cx-oracle.sourceforge.net/ onto a server running Windows Server 2003 Enterprise Edition and ActivePython 3.2.2.3 (ActiveState Software Inc.). I run the installer and the cx_oracle-doc directory and cx_Oracle-5.1.2-py3.2.egg-info are installed. I don't see cx_oracle.pyd in the site-packages directory. A search of the server doesn't find it. Is it part of the installer or do I need to build it?

If I need to build it then it is being a bear in Cygwin.  Below is the output

$ python setup.py build --compiler=mingw32 install
running build
running build_ext
Access is denied.
building 'cx_Oracle' extension
E:\cygwin\bin\gcc.exe -mno-cygwin -mdll -O -Wall -IE:\oracle\product\11.2.0\clie
nt_1\oci\include -IE:\oracle\product\11.2.0\client_1\rdbms\demo -IE:\Python32\in
clude -IE:\Python32\PC -c cx_Oracle.c -o build\temp.win32-3.2-11g\Release\cx_ora
cle.o -DBUILD_VERSION=5.1

Any ideas on how to make this work would be appreciated.

TIA,
Joe