On 4 Apr 2001, at 10:54, Julio Santiago wrote:
> in line: $dbh = DBI->connect($db_name,$user,$passwd,"Oracle");
>
> And that is why I want to find a way to test DBI
The usual syntax is something like
$dbh = DBI->connect("dbi:Oracle:$db_name", $user, $passwd)
or die "Can't connect: $DBI::errstr";
; I use something like this:
$dbh = DBI->connect('dbi:Oracle:', "$user/$passwd\@$sid", "", {
AutoCommit => 1, PrintError => 1 }) or die "Can't connect:
$DBI::errstr";
. Read the DBI and DBD::Oracle documentation (especially the latter)
for the connect syntax. There are a multitude of ways to specify the
connection string to DBD::Oracle.
Cheers,
Philip
--
Philip Newton <[EMAIL PROTECTED]>