[Zope] DCOracle Connection with Oracle 8.0.5

Celio C. Guimaraes celio@ic.unicamp.br
Wed, 13 Sep 2000 10:20:15 -0300


I have just installed the DCOracle package V 1.3.1b  on a Linux Red Hat
6.2,  to access an Oracle 8.0.5
Server with python1.6
I have run with success a few tests with the scott/tiger user tables,
however:

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

2)  I would like to connect to a remote oracle server. In this case the
@sid parameter is essential.
      How could this problem be fixed? Is it a simple parsing problem in
the oci_8.c Logon routine?
      which is the correct string to pe passed?
      @myserver.ic.unicamp.br:ora8  did not work either!

Celio Guimaraes
Institute of Computing
Unicamp - Brazil