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