This is my connection string in a script that no longer works. The file
has not been moved. I am not sure what file it cannot find.
$dbh = DBI->connect('dbi:ODBC:driver=Microsoft Access Driver
(*.mdb);dbq=F:/GROUPS/BUSINESS/BSS/safeguards/systems/testing/safeguards_test.mdb')
or die "Cannot connect to Safeguards Test database";
OUTPUT BELOW:
DBI = 1.37
DBD::ODBC = 1.07
PERL = 5.8.2
DBI connect('driver=Microsoft Access Driver
(*.mdb);dbq=F:/GROUPS/BUSINESS/BSS/s
afeguards/systems/testing/safeguards_test.mdb','',...) failed:
[Microsoft][ODBC
Microsoft Access Driver] Could not find file '(unknown)'. (SQL-HY000)(DBD:
db_lo
gin/SQLConnect err=-1) at F:\safeguards\SYSTEMS\TESTING\Dataload scripts
and dat
a\DATA\DENNIS\make_request.pl line 18
Cannot connect to Safeguards Test database at
F:\safeguards\SYSTEMS\TESTING\Data
load scripts and data\DATA\DENNIS\make_request.pl line 18.
--
Dennis M. Gray
Far East Information Resources Pty. Ltd.
91 Queen Street
BEACONSFIELD NSW 2015
AUSTRALIA
Sydney Phone: (02) 9310 7907
Sydney Fax: (02) 9310 7917
Mobile: (0418) 646267
Canberra Phone: (02) 6258 7917
