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("SE
>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 ma