Re: Redirecting DBI output

[David Shrewsbury]

You need to take a look at the documentation for DBI. The connect() subroutine expects a data source for the first parameter, a username as the second parameter and the password for the third. The fourth parameter is the hash reference with all of the options (like PrintWarn, AutoCommit, etc). If you are on a Unix system, you can read the DBI manual with the command:

man DBI

Here is an example:

$database = "my_database";
$user = "db_user";
$pass = "db_pass";
$dsn = "DBI:mysql:database=$database";
$dbh = DBI->connect($dsn, $user, $pass, {AutoCommit=>1, PrintWarn=>0});

-Dave