Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

Re: MS Access and Perl?

by socketdave (Curate)
on May 24, 2006 at 19:43 UTC ( #551443=note: print w/ replies, xml ) Need Help??

in reply to MS Access and Perl?

You don't need Access to set up an ODBC DSN to a .mdb file. A plain Windows (at least Windows 2000) install is enough.

Set up the DSN then use DBD::ODBC. At that point you can either use Activestate on the Windows box to connect to PostgreSQL on the remote machine or you can use DBI::ProxyServer and DBD::Proxy to connect from the *nix box back to the Windows box.

The former will probably require a little less work. I'd use the later if I needed ongoing access to the data in the .mdb and I wanted to keep my Perl all on the *nix box.

Update: To be clear, Activestate on the Windows machine is needed for either of these solutions...

Comment on Re: MS Access and Perl?
Re^2: MS Access and Perl?
by rhesa (Vicar) on May 24, 2006 at 20:17 UTC
    You don't even need to set up a DSN to talk to Access databases, you can simply pass the file name of the .mdb file:
    $dbh = DBI->connect(q{dbi:ODBC:driver=Microsoft Access Driver (*.mdb); +dbq=\\fooserver\path\source.mdb}, '', '');

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://551443]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (12)
As of 2014-08-20 06:58 GMT
Find Nodes?
    Voting Booth?

    The best computer themed movie is:

    Results (105 votes), past polls