RE: :ODBC configuration of DSN within program.

[Michael Blackmore]

Dear All,

This code snippet shows the solution:
The only trick is that you need to double escape the directories if you
specify them in a string.
 ...

my $dbfile = "v:\\\\mdbs\\\\perlmdb.mdb";
my $dsn = "driver=Microsoft Access Driver (*.mdb);dbq=$dbfile";
my $dbh = DBI->connect("dbi:ODBC:$dsn") or die "$DBI::errstr\n";

 ...

Cheers,

Michael.