[Zope-DB] DCOracle2 connection

[Matthew T. Kromer]

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.