DBD::ODBC Connection no longer working

From: Dennis M. Gray (d0325mgray_at_fareast.com.au)
Date: 04/19/04


Date: Mon, 19 Apr 2004 13:06:26 +1000 (EST)
To: dbi-users@perl.org

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


Relevant Pages

  • MS Access, scripts clashing
    ... I have a script which writes to an Access 2002 database. ... I'm using DBI over DBD::ADO with this connection string: ... I have two scripts that run at the same time, and both of them write to ... I've searched for DBI Access Locked, ...
    (perl.dbi.users)
  • Re: Connection String/Network Library
    ... Beyond that it's most likely NOT the connection string, ... Site & Scripts: http://www.Darkfalz.com ... > General Network Error on any page that connects to SQL Server. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Provider keyword in connection string not a valid keyword
    ... J. Muenchbourg wrote: ... > I have a connection string in Web.config that works with my dreamweaver ... > type asp.net scripts: ...
    (microsoft.public.dotnet.general)