[Zope] DCOracle Connection with Oracle 8.0.5

Dieter Maurer dieter@handshake.de
Wed, 13 Sep 2000 22:01:31 +0200 (CEST)


Celio C. Guimaraes writes:
 > 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!
We use this DCOracle version under Solaris 2.7 with
Oracle 8.1.6 without problem.
Especially, the "@host" works.

Thus, it does not look like a DCOracle problem.



Dieter