Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
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
  • Outside of code tags, you may need to use entities for some characters:
            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 drinking their drinks and smoking their pipes about the Monastery: (5)
    As of 2014-12-19 02:35 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      Is guessing a good strategy for surviving in the IT business?





      Results (70 votes), past polls