Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

DBD driver for MS Access

( #156235=categorized question: print w/ replies, xml ) Need Help??
Contributed by samgold on Apr 03, 2002 at 05:02 UTC
Q&A  > database programming


Description:

I am trying to figure out how to connect to an access database using DBI. I have DBI, DBD::ADO and libwin32. I keep getting an error cannot find win32::OLE in @INC... In my code I have use DBI; use DBD::ADO; If I leave out the use DBD::ADO I get the error: Can't locate object method "connect" via package "DBI". Any ideas?

Answer: DBD driver for MS Access
contributed by simon.proctor

Use Win32::OLE or DBD::ODBC. I've had better results with Win32::OLE but thats because of having to use Memo fields (etc). Take a look at:

  1. Cannot insert into MS Access Memo field with DBI
  2. Retrieving the last insert ID with Access
Hope that helps.
Answer: DBD driver for MS Access
contributed by beebware

Use DBI and DBD::ODBC (steer away from Win32::ODBC as when you migrate to a 'better' database system you won't need to change much). I would recommend using MySQL instead of Access databases though: it's free and multi-platform PLUS it supports larger tables than Access (ok, so it hasn't got the handy GUI interface but still)...

Answer: DBD driver for MS Access
contributed by samgold

I prefer oracle personally, that could be because I am an Oracle DBA :) My wife is a web designer, developer and an Access developer. I am teaching myself CGI and HTML to try to help her out with a project that involves an access database. Thank you for the suggestions, I am going to look into both DBD::ODBC and Win32::OLE.

Please (register and) log in if you wish to add an answer



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.
  • Log In?
    Username:
    Password:

    What's my password?
    Create A New User
    Chatterbox?
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others surveying the Monastery: (7)
    As of 2015-07-04 14:26 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









      Results (60 votes), past polls