[Zope-DB] DCOracle2 connection
Matthew T. Kromer
Tue, 04 Feb 2003 12:11:27 -0500
Tena Sakai wrote:
>I'd like to create a DCOracle2 database connection.
>The connection string should look like, say:
>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.
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.