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
|
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 | [reply]
[d/l]
[select] |
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. | [reply] |
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. | [reply] |
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.
| [reply] |
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
| [reply] |