What error did the DBI give you ($DBI::errstr that you are outputting to
STDOUT)? Also use DBI->trace(2, "filename") and then look in the "filename"
file for the trace of the process. Send that file in if you can't see the
problem.
Ilya Sterin
-----Original Message-----
From: Mitch Clarvit
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: 03/07/2001 2:23 AM
Subject: Connecting to Oracle 8i on Novell NetWare 5.1
My apologies to everyone for my lack of expertise - this forum has
certainly taught me a lot about Perl. I have a new assignment which
involves connecting to an Oracle 8.1.5 database which resides on a
Novell Netware 5.1 server on a seperate volume called "Oracle" then the
"SYS" volume for all you Novell guru's. The version of Perl being used
is 5.003_07 (Netware build #333).
My code fails on the DBI connect statement:
$dbh = DBI->connect("dbi:Oracle:$sid",$user,$password {
RaiseError => 1 }) or die "Can't connect:$DBI::errstr\n";
I have tried 2 other approaches to this statement:
$dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid",$user,$password {
RaiseError => 1 }) or die "Can't connect:$DBI::errstr\n";
-AND-
$dbh = DBI->connect("dbi:Oracle:$tnsname",$user,$password {
RaiseError => 1 }) or die "Can't connect:$DBI::errstr\n";
I would appreciate any suggestions to get the code to work. I wish I
could check error messages, but being so new to the Novell operating
system, I don't know where to look for the logs.
Thanks in advance,
Mitch Clarvit
[EMAIL PROTECTED]
