when I was calling the function from a shell it was importing DCOracle2 from the /usr/lib/python calling it from within zope is importing DCOracle2 from $ZOPE_HOME/bin/python It appears that these two copies of DCOracle2 are different. So I solved the problem by copying DCOracle2 from the standalone python into $ZOPE_HOME/lib/python2.1/site-packages. So far it is working. I hope this will not be a problem down the road. I would be very interested to understand why these two copies behave differently?? Thanks for your response Bogdan, -Hara -----Original Message----- From: Bo M. Maryniuck [mailto:b.maryniuk@forbis.lt] Sent: Wednesday, October 02, 2002 12:50 AM To: Dilley, Hara; zope@zope.org Subject: Re: [Zope] DCOracle2 On Wednesday 02 October 2002 01:27, Dilley, Hara wrote:
I have an external method calling a function that is connecting to an Oracle database using DCOracle2. When I call this function from the shell it runs fine; connects to the database. From zope however it doesn't work. It errors out at the DCOracle2.connect(connectionstring). Any help on this or any information on how to debug this error would be greatly appreciated.
You import DCOracle2 from which Python: /usr/lib/python/ or $ZOPE_HOME/bin/python? Check anyway for: 1. Oracle environment is for Zope. 2. your database is in /oracle/network/admin/tnsnames.ora 3. Set up "Stupid log"? -- Regards, Bogdan Science is to computer science as hydrodynamics is to plumbing.