Here's what I use:
use DBI;
use diagnostics;
use strict;
my ($dbh,$sth);
my ($dbname)=pickle;
my ($login)=picklesql;
my ($password) =pi56fb;
my (@ary);
#
$dbh = DBI-connect(DBI:mysql:$dbname,$login,$password)
or die Can't connect to $dbh: $dbh-errstr\n;
$sth = $dbh-prepare(SELECT * FROM
From the DBI manual:
$dbh = DBI-connect($data_source, $username, $auth, \%attr);
You're not telling DBI what the DSN is (Data source name)
John Mayson wrote:
I've decided to graduate to the next step and access my mySQL databases with Perl. I
am attempting this on a Win2000