Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (5)
As of 2014-12-19 03:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (70 votes), past polls