Connecting from Unix to MS Access DB

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Hello all,

I'm after querying a Microsoft Access DB from a Unix webserver using scripts programmed in Perl.

I've tried looking for modules but have come up with so little - I think this needs to be done using ODBC.

Anyone have any experience here?...

Comment on Connecting from Unix to MS Access DB

Replies are listed 'Best First'.
Re: Connecting from Unix to MS Access DB by Kanji (Parson) on Nov 16, 2000 at 19:13 UTC
IIRC, Access doesn't support network connenctions so you need some sort of bridging mechanism, be it a DBD::Proxy / DBI::ProxyServer combo (both part of DBI), or a commercial solution like Easysoft's ODBC-ODBC Bridge. I can't speak for the latter, but the DBD::Proxy solution does work after a fashion, although the problem I hit (only get a single concurrent connection thanks to the way Net::Daemon worked on Win32) was pretty much a show stopper for my purposes. --k.	[reply]
Re: Connecting from Unix to MS Access DB by jptxs (Curate) on Nov 16, 2000 at 18:53 UTC
If you need to access any database, your first stop is the Perl DBI, which is a database independant way of accessing data. It can do ODBC and many other ways to get at data. Also see Programming the Perl DBI the definative book about the DBI right now. Buy it through that link and perlmonks.org gets a kickback : ) `<myExperience> $mostLanguages = 'Designed for engineers by engineers.'; $perl = 'Designed for people who speak by a linguist.'; </myExperience>` [download]	[reply] [d/l]