Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

MySQL on Windows

by perleager (Pilgrim)
on Apr 25, 2002 at 12:24 UTC ( #161928=perlquestion: print w/replies, xml ) Need Help??

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

Hello:

I have MySQL 4.0 installed on Win2k server. I wanted to use Perl for MySQL so I figured I would use DBI for this?

Is using DBI possible on a Win2k server ?

If not, what can I use?

Thank you

Replies are listed 'Best First'.
Re: MySQL on Windows
by Putzfrau (Beadle) on Apr 25, 2002 at 12:59 UTC
    Yes you can, It's easiest to install DBI if you've got ActiveState Perl and have PPM at your disposal. Just activate PPM from the perl/bin directory (usually c:\perl\bin).
    >PPM
    then install DBI
    >Install DBI
    the rest of the install is automatic
    This is how i got DBI installed on our school's win2k test server it's not much advice and I might be wrong, but I hope it helps you out

    "when a new client is created, we have to kill all the children..." --Sams Teach yourself Perl 5
Re: MySQL on Windows
by AidanLee (Chaplain) on Apr 25, 2002 at 12:56 UTC
    I have done this without any issues. As long as you've got normal perl cgi scripts running ok on your web server, adding DBI to the mix is a non-issue.
Re: MySQL on Windows
by drewbie (Chaplain) on Apr 25, 2002 at 13:43 UTC
    Yes, DBI is the right solution.

    Yes, DBI is available for Win32. As Putzfrau mentioned, PPM and ActiveState is your friend on Windows. And there are many sources for PPM versions of popular modules. Randy Kobes even has a PPM of mod_perl for windows, which works quite well.

Re: MySQL on Windows
by Sifmole (Chaplain) on Apr 25, 2002 at 12:49 UTC
    I have used the DBI libraries on windows to access a MySQL database. I was not running the Win2K server, but Apache instead; But I would believe the DBI would still work. Your best bet is to just try it by creating a quick and dirty script to find out.
Re: MySQL on Windows
by ckohl1 (Hermit) on Apr 25, 2002 at 15:29 UTC

    Getting to a MySQL server on a Windows 2000 machine is not a problem. If your scripts are running on a Win32 box, you have a couple of options for reaching the database. You can use Win32::ODBC package to access the database, or use DBI with either the ODBC or MySQL interface. If your scripts are running on a non-Win32 platform, then you probably will not be able to use the Win32::ODBC package (never say never).


    PS: The ppm install directive for the MySQL interface to DBI is 'install DBD-Mysql'.



    Chris

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://161928]
Approved by rob_au
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (3)
As of 2022-06-26 19:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My most frequent journeys are powered by:









    Results (86 votes). Check out past polls.

    Notices?