Vincent,
Your DBD is linked against the 8.1.6 libs, but you set your ORACLE_HOME to the 7.3.4
distribution. This is, as said before, asking for trouble. You should set your
ORACLE_HOME
to point to the 8.1.6 distribution, since that's where the libs reside you need to link
with.
If your tnsnames.ora is set up correctly, everything should work.
Oh, don't forget to check your LD_LIBRARY_PATH. It should contain $ORACLE_HOME/lib
(where
ORACLE_HOME points to 8.1.6, of course).
Brgds,
Mark
Vincent Roquencourt wrote:
> On Tue, May 29, 2001 at 10:28:01AM +0100, Tim Scott wrote:
> > 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
>
> Hi Tim,
> thanks for your quick reply, however i just tested it:
> $ENV{ORACLE_HOME}= '/export/home/oracle/app/oracle/product/7.3.4';
> $ENV{ORACLE_SID}='mydb';
> print "$ENV{ORACLE_HOME} .... $ENV{ORACLE_SID}\n";
> if( !( $dbh = DBI->connect($ENV{ORACLE_SID},$USER,$PASS, 'Oracle') ) ) {
> print "not connected\n $DBI::errstr";
> }
> else{
> print "connected\n"
> };
>
> #this is supposed to connect using tnsnames.ora (sqlplus $USER@mysid works with both
>db)
> i get the same error with the 7.3.4:
>
> /export/home/oracle/app/oracle/product/7.3.4 ....mydb
> not connected
> ORA-01005: null password given; logon denied (DBD ERROR: OCISessionBegin)
>
> but not with the 8.1.6!
> /export/home/oracle/app/oracle/product/8.1.6 .... deuro
> connected
>
> user exists on both db (tested with sqlplus via sqlnet)
>
> HEEEELp!!! :)
>
--
Mark Vandenbroeck Mobile : +32-495-59.55.62
Business Process Manager Email : [EMAIL PROTECTED]
EMEA Support Information Systems AIM : markvdb
