[EMAIL PROTECTED] wrote:
Hello,
I have been trying to extract data from a access.mdb file using perl5,
DBI-1.40, DBD-ODBC-1.07, unixODBC-2.2.7, and libmdbodbc.xx driver from
mdbtools. I have seen many sources and posts proclaiming the possibility
to avoid needing to define DSN's by connecting similar to the following:
my $DSN = 'driver=Microsoft Access Driver
(*.mdb);dbq=\\\\cheese\\g$\\perltest.mdb'; my $dbh =
DBI->connect("dbi:ODBC:$DSN", '','') or die "$DBI::errstr\n";
This works for me:
my $dbq = 'd:/htdocs/a/test-data/test.mdb';
my $drv = 'Microsoft Access Driver (*.mdb)';
my $dbh = DBI->connect("dbi:ODBC:DRIVER=$drv;DBQ=$dbq",...);
--
Jeff
