[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