Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

Re: Perl & Microsoft Access

by jZed (Prior)
on Jan 13, 2005 at 18:47 UTC ( #422066=note: print w/replies, xml ) Need Help??

in reply to Perl & Microsoft Access

Hopefully you wrote your programs using DBI and DBD::mysql. If you did, you should be able to switch the programs to use MS Access by using DBD::ODBC instead of DBD::mysql. See the DBD::ODBC docs for details of setting up a DSN for MS Access

Replies are listed 'Best First'.
Re^2: Perl & Microsoft Access
by merrymonk (Hermit) on Jan 14, 2005 at 08:07 UTC
    I know that I used DBI since I have a ‘use DBI’ statement in my Perl module. However, I do not know if I have used DBD::mysql since I have made no reference to it. If it is of any help to solve this question my ‘connection’ statement is of the following form $dbh = DBI->connect($dsn, ‘user’, ‘password’) where $dsn includes a reference to ‘DBI:mysql:host, the host name and the data base name.
    If I am using the two facilities that you have referred to does it mean that it is as simple as replacing the ‘use DBI’ with ‘use DBD::ODBC’ and then making some changes to the connection call that reflect the need to connect to Access rather than MYSQL?
    I apprecaite that this is probably a very simple question but is there a web page that has the DBD::ODBC docs?
      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://422066]
[Corion]: Yay. I've now published (at $work) that random Excel workbook where on one sheet you enter your SQL and on the other sheet, you have a button and receive the results. I'm so evil in enabling cow-orkers to self-supply ;)
[Corion]: It's close to my Perl script where you paste in the SQL and get the result as XLSX file, but I guess the Excel sheet is more user-friendly :)
[choroba]: What drivers does it support? ;-)
[erix]: sounds cool -- but now you have to give SQL lessons?

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (9)
As of 2018-07-18 13:02 GMT
Find Nodes?
    Voting Booth?
    It has been suggested to rename Perl 6 in order to boost its marketing potential. Which name would you prefer?

    Results (392 votes). Check out past polls.