[Zope-DB] Problem after ZOracleDA install

Dieter Fischer dieter.fischer@grid-it.ch
Thu, 27 Feb 2003 13:40:05 +0100


Hello Dominik

As I remember ZOracleDA is the old Oracle adapter (zope.org is in
maintainance now), you should use DCOracle2 (for Win DCOracle2-1_2.zip)

---

Mit freundlichen Gr=FCssen - Meilleures salutations - Kind regards - Cord=
iali
saluti

Dieter Fischer
Grid IT GmbH
Im Niederholzboden 24
CH-4125 Riehen
Tel: +41 61 601 29 62
mailto:dieter.fischer@grid-it.ch
http://:www.grid-it.ch


> -----Original Message-----
> From: zope-db-admin@zope.org [mailto:zope-db-admin@zope.org]On Behalf O=
f
> K=E4uferle Dominik
> Sent: Thursday, February 27, 2003 11:19 AM
> To: 'zope-db@zope.org'
> Subject: [Zope-DB] Problem after ZOracleDA install
>
>
> Hy
>
> I am currently trying to make an Oracle DB Connection from Zope using t=
he
> 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 ou=
t
> something when installing?
>
> Any ideas? Your help is much appreciated
>
> regards
> Dominik
>
> test py script empnotest.py
> ---------------------------
> import DCOracle2 # Import runtime
> db =3D DCOracle2.connect('scott/tiger') # Connect to database
> c =3D db.cursor() # Allocate a cursor
> c.execute('select * from emp where empno=3D7902') # 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=3DC:\Programme\Oracle\lib
> ORACLE_HOME=3DC:\Programme\Oracle
> ORACLE_SID=3DT000
> OS=3DWindows_NT
> Os2LibPath=3DC:\WINNT\system32\os2\dll;
> Path=3DC:\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\syst
> em32;C:\WI
> NNT;
> C:\WINNT\System32\Wbem
> PATHEXT=3D.COM;.PL;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.py;.
> pyc;.pyo;.
> pyw;
> .pys
>
>
>
>
> *******************************************************************
> Dominik K=E4uferle
> Dipl. Natw. ETH, Geoinformatiker
> GIS-Koordinationsstelle / Vermessungsamt
> Zentralstr. 28, 6002 Luzern
> dominik.kaeuferle@lu.ch
> *******************************************************************
>
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://mail.zope.org/mailman/listinfo/zope-db
>