Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
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...

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

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://551443]
help
Chatterbox?
[Corion]: 1nickt: I bought a 2015 XPS 13, which is a very nice and shiney (and somewhat overpriced) machine, but I think it's still better priced than an Apple machine. Now it just has to hold up 10 years like the old one did ;)
[1nickt]: Ah, you got Linus' fave? With Ubuntu? 4k display?
[1nickt]: ( The 17" monster I just bought is for my wife, who doesn;t leave the house with it...)
[Corion]: 1nickt: No, I'm using it with Windows 10, but with the 4k display, yes. It's a very nice build IMO, and relatively sturdy. Also, it got 8 or 9 on the ifixit repair scale, which I consider good
[Corion]: ... especially as I expect to have to replace the battery set in two or three years' time

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (12)
As of 2017-03-27 13:09 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Should Pluto Get Its Planethood Back?



    Results (320 votes). Check out past polls.