Hi,
I create a new database in MySQL and connecting it using Perl.But i am getting "unable to connect database" error. If i connect the default database available in the MySQL(default during the installation) then the program working fine. Can any one help me regarding this.
#!/usr/local/bin/perl
use DBI;
$dbh = DBI->connect('dbi:mysql:ram','root','root')
or die "Connection Error: $DBI::errstr\n";
$sql = "select * from test1";
$sth = $dbh->prepare($sql);
$sth->execute
or die "SQL Error: $DBI::errstr\n";
while (@row = $sth->fetchrow_array) {
print "@row\n";
}
error: DBI connect('ram','root',...) failed: Unknown database 'ram' at C:\Documents and
Settings\Admin\Desktop\test.pl line 3
Connection Error: Unknown database 'ram'
Thanks in advance
Ram