Hello,
I am having a hard time trying to connect to a Oracle DB.
If I use:
my $dbh = DBI->connect('dbi:Oracle:', "$user/$passwd\@$sid", "", {
AutoCommit => 0, RaiseError => 1, PrintError => 1 }) or die "Can't
connect:$DBI::errstr";
the connection works fine and everything runs smooth.
When I try connecting using:
my $dbh = DBI->connect("dbi:Oracle:HOST=$host;SID=$sid", $user, $passwd, {
AutoCommit => 0, RaiseError => 1, PrintError => 1 });
I get the error
DBI->connect(HOST=myhost;SID=ORC_ID) failed: r (DBD: login failed, check
ORACLE_HOME/bin is on your PATH) at err_test.pl line 10
The thing is how do I set the path?
Thanks
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
