http://www.perlmonks.org?node_id=156235

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

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?

Replies are listed 'Best First'.
Re: DBD driver for MS Access
by simon.proctor (Vicar) on Apr 03, 2002 at 08:13 UTC
Re: DBD driver for MS Access
by beebware (Pilgrim) on Apr 03, 2002 at 13:25 UTC
    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)...
Re: DBD driver for MS Access
by samgold (Scribe) on Apr 03, 2002 at 05:58 UTC
    I think I need to read some more........

    Originally posted as a Categorized Answer.

Re: DBD driver for MS Access
by samgold (Scribe) on Apr 04, 2002 at 03:11 UTC
    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.