perhaps?, change your single-slash (\) to double-slashes (\\)
ie.,
CHANGE:
$dsn='Driver=Microsoft Access Driver (*.mdb);DBQ=d:\data.mdb';
TO:
$dsn='Driver=Microsoft Access Driver (*.mdb);DBQ=d:\\data.mdb';
-----Original Message-----
From: Krung Saengpole [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 12:38 PM
Subject: DSNless connection.
Dear all,
I have another easy problem (yours), how can I connect to Access database with
DSNless DBI? I try below:
$dsn='Driver=Microsoft Access Driver (*.mdb);DBQ=d:\data.mdb';
$dbh=DBI->connect("DBI:ODBC:$dsn",'','',{RaiseError=>1})
or die $DBI::errstr ;
It couldn't connect to database. But if I use DSN instead of $dsn, it could do.
What wrong with my script?
Thank you in advance.
Krung
