Voncent,
You'd be better to setup a tnsnames entry in your Oracle8.1.6 area to point
at your Oracle 7.3.4 database and using this as a connect string.
If you don't do this, you're using Oracle8 function calls from your Perl/DBI
build to try to talk to an Oracle7 database. This is asking for trouble -
even if you do eventually connect.
Regards,
Tim
----- Original Message -----
From: "Vincent Roquencourt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 9:56 AM
Subject: Connection pb with 2 oracle version! Please help!
> Hi,
> using DBI, DBD::Oracle without any problem since 2 years i came
> acrossa weird behaviour:
> Environnement: Solaris 2.6
> Oracle 8.1.6 AND 7.3.4 on same machine
> DBI 1.15
> DBD 1.06
>
> Since yesterday i recompiled DBD,DBI with oracle 8.1.6 environnment.
> I can connect to the 8.1.6 db but now i can't connect to the 7.3.4!!
> here is the connection line of my script
> $ENV{ORACLE_HOME} is set to 7.3.4 ORACLE_HOME,
> $USER and $PASS are set in the script,
>
> if( !( $dbh =
DBI->connect("dbi:Oracle:host=mmyhost;sid=$sid",$USER,$PASS))) {
> push @dbs_down,$sid;
> }
>
> i get the following error when i tried to connect to the 7.3.4
> DBI->connect(host=myhost;sid=xxx) failed: ORA-01005: null password given;
logon
> denied (DBD ERROR: OCISessionBegin) at oracle-bb.pl line 59
>
> everything is fine with the 8.1.6 db..
>
> what is the problem? can t i connect to 2 version of oracle db?
>
> thanks
>
>
>
>
>
>
> --
> Vincent Roquencourt
> Business Objects
> DBA Team
