[Zope-DB] DCOracle2 connection

Matthew T. Kromer matt@zope.com
Tue, 04 Feb 2003 12:11:27 -0500

Tena Sakai wrote:

>Greetings folks,
>I'd like to create a DCOracle2 database connection.
>The connection string should look like, say:
>      moo/goo@gaipan
>It fails when I test it (using "test" tab).  The failure is:
>      Invalid connection string: moo/goo@gaipan
>What puzzles me is that when I use SQLPLUS to test the
>very same connection, it works.  (So does tnsping.)
>Would anyone please enlighten me as to what is going on?
>Thanks in advance.
>Tena Sakai

That's usually caused by a failure of the underlying C code to 
initialize, either because it doesn't have ORACLE_HOME set properly and 
the LD_LIBRARY_PATH including the Oracle shared libs, or because a 
permission problem prevents Zope from reading out of ORACLE_HOME.