Out of curiosity, why wouldn't you use a DSN?
Eric
-----Original Message-----
From: Krung Saengpole [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 12:38 PM
To: [EMAIL PROTECTED]
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