Sorry Guys,
I checked my .profile and there is a line that says:
PATH=$PATH:$ORACLE_HOME/bin; export PATH
Is there any other way to connect to the DB remotely than the onesused
below?
>From: "Julio Santiago" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: DB Connection (Dumb Question)
>Date: Thu, 10 May 2001 16:44:19 -0400
>
>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.
>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
