Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?

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...

Replies are listed 'Best First'.
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]
[Corion]: marto: How's things? I hope the kids are fine and you too!
[Corion]: Oh yay. I wonder why a very simple change in a program doesn't elicit a diff, and now I see that my diff program seems to have a bug ;)
[1nickt]: marto thanks for asking, so far so good. A pretty modern stack and decent procedures, although rather too much home-built stuff (e.g. a logging role that should tries to duplicate Log::Any).
[Corion]: No. It's just that I'm comparing the same output file twice, instead of comparing the output files of the two runs %-)
[Corion]: Lo and behold, running a program with the correct input files yields the correct (and expected) output. Yay me.
[1nickt]: Got a MacBook and am expected to develop directly on it, ironic given the recent thread about that.
[marto]: Corion, some not too serious issues with the kids, hopefully, other than that just dealing with commuting by car again in the winter, not much fun so far, and there's no real 'bad' weather yet :)

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (5)
As of 2017-12-11 11:39 GMT
Find Nodes?
    Voting Booth?
    What programming language do you hate the most?

    Results (289 votes). Check out past polls.