Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

DBD driver for MS Access

by samgold (Scribe)
on Apr 03, 2002 at 05:02 UTC ( #156235=perlquestion: print w/replies, xml ) Need Help??

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 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.
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.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://156235]
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: (3)
As of 2022-08-09 20:56 GMT
Find Nodes?
    Voting Booth?

    No recent polls found