DBD driver for MS Access

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?

Comment on DBD driver for MS Access

Replies are listed 'Best First'.
Re: DBD driver for MS Access by simon.proctor (Vicar) on Apr 03, 2002 at 08:13 UTC
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: Cannot insert into MS Access Memo field with DBI Retrieving the last insert ID with Access Hope that helps.	[reply]
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)...	[reply]
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.	[reply]
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.	[reply]