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

I have Activestate Perl 5.005_3, running on Windows 95. I host my own site at www.argenteen.com . Right now, all the databases in the site are flat files, but I thought it would be interesting to make an upgrade to real databases. I'm planning on having the databases made with Microsoft Access, but I can't connect to them in any way with Perl. I was wondering if there is any equivalent for the DBI module, in windows, since it seems like it is really easy to use, and powerful. Thanks a lot! My email is: webmaster@argenteen.zzn.com

Replies are listed 'Best First'.
Re: DBI Module for Windows
by davorg (Chancellor) on Aug 18, 2000 at 13:58 UTC

    The DBI module should work under Win32 without any problems. You can use the DBD::ODBC module to connect to Access databases. Both of these modules are available from ActiveState's module repository.

    Another option would be the Win32::ODBC module, but that's guaranteed to be non-portable.

    --
    <http://www.dave.org.uk>

    European Perl Conference - Sept 22/24 2000, ICA, London
    <http://www.yapc.org/Europe/>
      Just to add a small note: By using PPM (just type ppm at the commandprompt) you can install the DBI and DBD::ODBC modules from the modulerepository. Jouke Visser, Perl 'Adept'
      Depending on how much of Win32::ODBC you use, it is not hard to write a small wrapper around DBI to make it look like Win32::ODBC. I did a workable one for myself in a couple of hours when I needed to cheaply port some scripts...
DBI is dying - Hardly
by coreolyn (Parson) on Aug 18, 2000 at 18:34 UTC
    From what I can see from monitoring the dbi mailing list, news of dbi's death is quite premature. Tim Bunce author of DBI seems as committed as ever and is already looking ahead to how to keep dbi migrating into perl 6 when the time comes. I'd love to know who (what your sources) are on dbi dying. On the surface it sure looks like you've made a very irresponsible post.

    coreolyn Duct tape devotee.
    -- That's OO Perl, not Oh! Oh! perl :)

A reply falls below the community's threshold of quality. You may see it by logging in.