Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

Re^3: Perl & Microsoft Access

by jZed (Prior)
on Jan 14, 2005 at 14:46 UTC ( #422249=note: print w/replies, xml ) Need Help??

in reply to Re^2: Perl & Microsoft Access
in thread Perl & Microsoft Access

You do not need to specifically "use" DBD::mysql, or DBD::ODBC, you are already using it correctly: use DBI, then refer to the driver in the connect() call and DBI will load the DBD for that driver automatically. And yes, changing ODBC for mysql is the main thing you will have to do. (I'm assuming you have DBD::ODBC installed, if not use ppm to get it or go here to download DBD::ODBC). You will probably need to set up a system DSN for your database or else google for DSN-less connection to create on-the-fly ODBC connections. Other needed changes may or may not be simple, depending on whether you used SQL that is specific to MySQL, if you're just doing simple connections and queries, you should be fine. The docs for DBD::ODBC (and all perl modules) are in the modules themselves, you can get to them with perldoc DBD::ODBC on the command line, or by Start Menu - Programs - ActivePerl - Documentaion, or by looking on CPAN, for example the DBD::ODBC documentation online.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://422249]
[Corion]: A good daystart everybody!
[Happy-the-monk]: Goody-goody!
[Discipulus]: still happy Happy-the-monk? even in 2018? good for you.. ;=)
[choroba]: Good morning!

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (6)
As of 2018-01-23 08:42 GMT
Find Nodes?
    Voting Booth?
    How did you see in the new year?

    Results (242 votes). Check out past polls.