[Zope-DB] DCOracle2 connection

Tena Sakai tena.sakai.b@bayer.com
Tue, 4 Feb 2003 13:56:25 -0800

Many thanks, Matt.  I got it.


                      "Matthew T.                                                                                                
                      Kromer"                  To:       Tena Sakai <tena.sakai.b@bayer.com>                                     
                      <matt@zope.com>          cc:       zope-db@zope.org                                                        
                      Sent by:                 Subject:  Re: [Zope-DB] DCOracle2 connection                                      
                      02/04/2003 09:11                                                                                           

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.

Zope-DB mailing list