You may be getting a different set of environment variables in cgi than from
the command line. I had to put a "BEGIN" block in all of my cgi scripts - to
set environment - for the scripts to work in cgi...
Jwm
****
Interesting! I guess that explains the BEGIN block I recently inherited.
Context is Solaris and Oracle:-
use DBI;
use CGI;
#
# Database connect information
#
BEGIN {
$ENV{ORACLE_HOME} = q{/long/complicated/oracle/name};
$ENV{TWO_TASK} = q{blah.fred.com};
$uid = q{auserid};
$pw = q{apassword};
}
Thanks for the explanation.
****
And for the OP: you probably should use something like:-
my $dbh = DBI->connect("dbi:Oracle:ora817", $oraUser, $oraPass) or die
"Can't connect for this reason: $DBI::errstr\n";
Oh, and if your server is Apache, look in its error.log.
HTH, GStC.
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
