I thought I had tried that, but I guess I didn't as I just tried that and it worked.
Thank you very much for your help.
Sometimes it seems like things won't work until they're threatened by asking someone who knows who it's supposed to work.
Can't count how many times I've witnessed that kind of quirk of fate at my workplace.
----------
From: M.W. Koskamp[SMTP:[EMAIL PROTECTED]]
Sent: Friday,April 12,2002 11:44 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: DBD::Oracle
DBD::Oracle
>Oracle's sqlplus determines what to use by whether or not TWO_TASK is set,
but the new-style >DBI->connect seems to want to force network connections
no matter what, regardless of >whether or not TWO_TASK is set, regardless of
whether the database is local or remote.
I dont have that problem.
It will connect locally in the following way:
assume $dbname contains the sid of the database
$ENV{ORACLE_HOME} ||= $ENV{ORA_ROOT} if $ENV{ORA_ROOT};
$ENV{ORACLE_SID} = $dbname;
$ENV{ORA_SID} = $dbname;
my $dbh=DBI->connect('DBI:Oracle:',$uid,$pwd,
{RaiseError =>0, AutoCommit =>0}) or die "$msg{ERRCNF}: " . DBI::errstr;
Maarten.
