[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