2.7.2 Installing ActiveState Perl on Windows

To install the MySQL DBD module with ActiveState Perl on Windows, you should do the following:

• Get ActiveState Perl from http://www.activestate.com/Products/ActivePerl/ and install it.
• Open a DOS shell.
• If required, set the HTTP_proxy variable. For example, you might try:

  set HTTP_proxy=my.proxy.com:3128
  

• Start the PPM program:

  C:\> c:\perl\bin\ppm.pl
  

• If you have not already done so, install DBI:

  ppm> install DBI
  

• If this succeeds, run the following command:

  install \
  ftp://ftp.de.uu.net/pub/CPAN/authors/id/JWIED/DBD-mysql-1.2212.x86.ppd
  

The above should work at least with ActiveState Perl Version 5.6.

If you can't get the above to work, you should instead install the MyODBC driver and connect to MySQL server through ODBC:

use DBI;
$dbh= DBI->connect("DBI:ODBC:$dsn","$user","$password") ||
  die "Got error $DBI::errstr when connecting to $dsn\n";

User Comments

The new version of ActivePerl ActivePerl-5.8.0.804-MSWin32-x86 requires you to recompile the DBD::mysql driver manually. The older PPM file on CPAN, WILL NOT WORK.

I never could resolve this problem in Perl 5.8. I have read around the internet that Perl 5.6 and Perl 5.8 are binary incompatible so libraries must be recompiled. However, every 5.8 version of DBD I could find did not work so I had to go back to Perl 5.6 and follow the instructions above to use DBD again.

http://search.cpan.org/src/JWIED/DBD-mysql-2.1024/README:

As of this writing, the above procedure won't work with ActivePerl 5.8.0, because so far a PPM for DBD::mysql is not available from the ActiveState server. I don't know why. However, Randy Kobes has kindly donated a PPM package
to his own repository. You can use this as follows:

ppm install http://theoryx5.uwinnipeg.ca/ppms/DBD-mysql.ppd

works perfectly for me with ActiveState Perl Version 5.8

I was unable to connect with the ftp server, however i found the ppd here:
http://www.cpan.org/authors/id/JWIED/DBD-mysql-1.2212.x86.ppd

i used ppm2 to install, ppm3 failed all attempts.

Using the Perl Package Manager, I was able to install DBD from the link that is given above and everything is working fine.

Many thanks to the author of the module.

And if you missed it above. Use install in ppm with the folowing URL as the first arguement.

http://theoryx5.uwinnipeg.ca/ppms/DBD-mysql.ppd

A better choice to ActiveState Perl, is your own build of Perl 5.8.0

Instructions on building Perl 5.8.0 for Windows 2000/XP

http://www.devside.net/web/server/win32/perl

Add your own comment.