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

DBI Module for Windows

by Anonymous Monk
on Aug 18, 2000 at 13:53 UTC ( #28453=perlquestion: print w/replies, xml ) Need Help??
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 . 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:

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.


    European Perl Conference - Sept 22/24 2000, ICA, London
      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 :)

Re: DBI Module for Windows
by AgentM (Curate) on Aug 18, 2000 at 18:16 UTC
    dbi is dying use myodbc instead for greater portability link here
      How so?
      have I missed something?
        yep! perl6 won't like dbi, the API is not so hot, it does not exploit features of many dbengines and is not conveniently expandable. myODBC supplies a better API anyway. (dbi is cluttered with old cr*p like worthless "deprecated" booleans and decided that all databases function the same as MySQL especially when it comes to memory handling.) dbi is still labeled as "experimental" or "incomplete" and that it certainly is, even though it has been out since the first releases of Perl 5. This should tell you that no one is interested in continuing work on this module. dbi does have some nifty funcs like it's _ref funcs but other than that, it offers few advantages over MyODBC which advertises itself as a replacement for DBI anyway.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://28453]
Approved by root
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (4)
As of 2018-03-19 08:54 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (236 votes). Check out past polls.