develooper Front page | perl.dbi.users | Postings from January 2007

Problems using an old version of DBI to connect to a remote Oracle 10g database

Thread Next
From:
dave.salisbury
Date:
January 8, 2007 12:03
Subject:
Problems using an old version of DBI to connect to a remote Oracle 10g database
Message ID:
CEF8A8946A6511468B0B486445F978AF01E283FD@E03MVZ1-UKDY.domain1.systemhost.net
Dear all,

Appreciate if someone can help me with this.

I have a Solaris 5.6 Generic_105181-33 box on which I have Perl version
5.005_03.
I also have Perl modules DBI (version 1.14) and DBD::Oracle (version
1.06 - I think?? - how can I check this?)
I am using the following string to connect to a remote Oracle 10g
instance:

my $dbh = DBI->connect
("dbi:Oracle:$environment",$nsm_login,$nsm_password) || die "Unable to
connect to $environment: $DBI::errstr\n";

...where $environment is the instance name - this is defined in
tnsnames.ora.

I am getting the following error:

ORA-03113: end-of-file on communication channel (DBD: login failed)

I can connect OK from the command line using:

sqlplus login/password@instance_name

I suspect that I need newer versions of Perl, DBI and DBD.

Can anyone confirm this?

Thanks,
Dave S

Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About