MySQL on Windows

[perleager]

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

[Putzfrau]

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

[AidanLee]

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.

[drewbie]

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.

[Sifmole]

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.

[ckohl1]

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