DBD::DBM::st execute failed: Cannot open .\Reference.lck: No such file or directory at C:/Perl/lib/DBD/File.pm line 574.
[for Statement "
Select * from Reference"] at DataBaseControl.pl line 22.
DBD::DBM::st execute failed: Cannot open .\Reference.lck: No such file or directory at C:/Perl/lib/DBD/File.pm line 574.
[for Statement "
Select * from Reference"] at DataBaseControl.pl line 22.
####
use strict;
use warnings;
use DBI;
my ($dbh, $sth);
my $Error_Message = "\nThere Was A Problem Connecting To The Database\n";
my $driver = 'DBM'; # e.g., mysql or ODBC or ???
my $dbusername = 'sa';
my $dbpassword = 'admin';
my $server = 'localhost';
my $database = 'Copyediting';
$dbh = DBI->connect("dbi:$driver:$database:$server", $dbusername, $dbpassword,
{'RaiseError' => 1, 'PrintError' => 1}
) || die "$Error_Message $DBI::errstr";
$dbh->{RaiseError} = 1;
for my $sql( split /;\n+/,"
Select * from Reference;
"){
my $sth = $dbh->prepare($sql);
$sth->execute;
$sth->dump_results if $sth->{NUM_OF_FIELDS};
}
$dbh->disconnect();
####
DBM
ExampleP
File
ODBC
Proxy
SQLite
Sponge
mysql