2.7.2 Установка ActiveState Perl на Windows

Для установки модуля DBD для MySQL под ActiveState Perl на Windows необходимо выполнить следующие действия:

• Получить ActiveState Perl с http://www.activestate.com/Products/ActivePerl/ и установить его.
• Открыть оболочку DOS.
• Если это необходимо, то установить переменную HTTP_proxy. Например, можно попытаться сделать следующее:

  set HTTP_proxy=my.proxy.com:3128
  

• Запустить программу PPM:

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

• Установить DBI, если этого еще не сделано:

  ppm> install DBI
  

• Если все прошло успешно, то запустить следующую команду:

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

Эти команды должны работать по крайней мере с версией ActiveState Perl 5.6.

Если приведенные выше команды у вас не работают, то вместо этого необходимо установить драйвер MyODBC и подключить сервер MySQL через 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

Add your own comment.