[Zope] [voipiri: Re: [Zope] DCOracle Connection with Oracle 8.0.5]

Riku Voipio Riku.Voipio@tietoenator.com
Thu, 14 Sep 2000 09:30:15 +0300

On Wed, Sep 13, 2000 at 10:20:15AM -0300, Celio C. Guimaraes wrote:
> 1) In order to connect successfully  I had to drop the @sid parameter:
>     dbc=DCOracle.Connect('scott/tiger@ora8')
>     returns with error:  ORA-12154 : TNS: could not resolve service name

I think this is default oracle behaviour. for local databases you 
set the $ORACLE_SID connect with username/passwd. For remeote databases
you set $TWO_TASK or connect with username/passwd@SID . 

You also need a correctly setup /etc/tnsnames.ora

Riku Voipio
09-862 60764