[Zope-DB] DCOracle2 - Invalid connection string

[Matthew T. Kromer]

Carsten.Hoff@BASF-IT-Services.com wrote:

>Hello together,
>both, compiling or installation of binaries, leads to the following prob.
>Test scripts say connection successfully tested.
>But inside Zope the Connection method gives:
>invalid connection string.
>
>env for ORACLE_HOME and LD_LIBRARY_PATH are set in the zope start script.
>
>System RH7.1 both python 1.5.2 and 2.1, Oracle Client 8.1.7.,
>DCOracle2-PR1.tar.gz, Zope 2.4.3.
>
>What am I doing wrong
>TIA carsten
>

Did I ever get back to you on this, Carsten?

Anyway, most of this time it has to do the the Oracle naming services, 
ie sqlnet.ora and tnsnames.ora.  Often the installer put in a 
NAMES.DEFAULT_DOMAIN in the sqlnet.ora, but the name is unqualified in 
tnsnames.ora.

Usually there's like a sqlnet.log file generated when the name isn't 
being resolved properly.