On Thu, Feb 09, 2006 at 04:06:50PM +0100, Michael Kebe wrote: > Hello DBI users, > > I need help/tips/suggestions whatever you can give. > > I am developing a Perl script that accesses two databases. One database is > a DB2 and the other is Oracle 8.0.4.4.0. I use ActivePerl 5.8.7 and loaded > the DBD::Oracle module (v1.16) via the PPM system of ActivePerl. The > connection to the DB2 is fine. But when I am trying to connect to the > Oracle 8 database I get the following error: > > ORA-03134: Connections to this server version are no longer supported. > > It looks like the old version of the oracle database is way too old :) But > it is no option to upgrade the database, because it is in production. > > I found version 1.15 of DBD::Oracle for the ppm system, but this doesn't > work either (same message). The changelog of version 1.16 says:"It no > longer supports the old Oracle 7 OCI Interface." I am not a oracle > specialist, but I don't think this is the point. > > I tried the Oracle Instant Client 10.2.0.1 -- same errormessage. Then I > tried the little bit older 10.1.0.4 of it. Still no luck. It looks like > Oracle has stopped the support of Oracle 8.
Oracle 10 no longer supports connecting to Oracle 8. > Finally I tried to connect via Java JDBC and it worked. Not with the > recent version of the JDBC driver but with an older one. Before I will > rewrite it in Java, I thought this mailing list is my last hope :) > > What should I do to get a connection from my little perl script? I have no > experience with ODBC, but I think it's the same problem there (yeah, the > database is pretty old). Install Oracle 9 and build DBD::Oracle using that. Tim.
