[Zope-DB] Problem after ZOracleDA install

[Käuferle Dominik]

Hy

I am currently trying to make an Oracle DB Connection from Zope using the
ZOracleDA product on a windows Oracle client machine. I have installed Zope
2.6.1, Python2.1 and ZOracleDA - running the install.py was successful.

When I run the simple sample script from the ZOracleDA docu, I get the error
that the DCOracle2 module cannot be imported (see below). Did I miss out
something when installing?

Any ideas? Your help is much appreciated

regards
Dominik

test py script empnotest.py
---------------------------
import DCOracle2 # Import runtime
db = DCOracle2.connect('scott/tiger') # Connect to database
c = db.cursor() # Allocate a cursor
c.execute('select * from emp where empno=7902') # Execute a statement
print c.fetchall() # Print all results


Error msg:
----------
C:\WINNT\system32>python "C:\Programme\DOK\cgi-bin\empnotest.py"
Traceback (most recent call last):
  File "C:\Programme\DOK\cgi-bin\empnotest.py", line 1, in ?
    import DCOracle2 # Import runtime
ImportError: No module named DCOracle2


Some Environment Variables:
---------------------------
LD_LIBRARY_PATH=C:\Programme\Oracle\lib
ORACLE_HOME=C:\Programme\Oracle
ORACLE_SID=T000
OS=Windows_NT
Os2LibPath=C:\WINNT\system32\os2\dll;
Path=C:\Programme\Oracle\bin;C:\Programme\Oracle\jre\1.3.1\bin;C:\Programme\
Orac
le\jre\1.1.8\bin;C:\Perl\bin\;C:\Programme\Python21\;C:\WINNT\system32;C:\WI
NNT;
C:\WINNT\System32\Wbem
PATHEXT=.COM;.PL;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.py;.pyc;.pyo;.
pyw;
.pys




*******************************************************************
Dominik Käuferle
Dipl. Natw. ETH, Geoinformatiker
GIS-Koordinationsstelle / Vermessungsamt
Zentralstr. 28, 6002 Luzern
dominik.kaeuferle@lu.ch
*******************************************************************