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


Hi Monk

I have installed the ActivePerl-5.10.0.1003-MSWin32-x86-285500.

Then I have installed DBI by using the command "ppm install DBI" and DBD-mysql-4.007 by using the command "ppm install DBD::mysql"

But still i am getting error when run the perl program "Loadable object for DBD::mysql not found".

I think it is a compatible problem of DBD::mysql with ActivePerl-5.10.0.1003-MSWin32-x86-285500.

Can anyone suggest me the the suitable versions of Active perl, DBI and DBD::mysql. So that it works fine or a suitable way to load the drivers for mysql.

Regd's
Sanjay

Replies are listed 'Best First'.
Re: How to install Mysql drivers for Perl?
by Corion (Patriarch) on Oct 01, 2008 at 11:19 UTC

    You also need the MySQL client libraries installed.

[reply]
    A reply falls below the community's threshold of quality. You may see it by logging in.
Re: How to install Mysql drivers for Perl?
by agent00013 (Pilgrim) on Oct 01, 2008 at 18:28 UTC
    At present, there is not a DBD::mysql module compatible with ActivePerl 5.10 on Windows. I checked all the repositories I could, tried compiling it myself, and nothing worked. (This was yesterday, September 30, 2008.)

    I installed ActivePerl 5.8.8 instead and have a much easier time finding and installing compatible modules. You can download ActivePerl 5.88 from ActiveState. I was then able to install the DBD::mysql module using the following instructions from its CPAN module page:

    Instructions
    As of this writing, DBD::mysql is missing in the ActivePerl 5.8.0 repository. However, Randy Kobes has kindly donated an own distribution and the following might succeed:

    ppm install http://theoryx5.uwinnipeg.ca/ppms/DBD-mysql.ppd
    Hope this helps!
[reply]
[reply]
        Thank you so much for providing the solution. It help me a lot. Thank you.
[reply]

      Hi

      Thanks a lot for your suggestion. The DBD::mysql has installed fine. Now i can connect perl with mysql without any error.

      Regd's
      Sanjay
[reply]
        You can simply download xampp which include perl package in it. From the perl package, it has mysql module already installed for you. xampp will also install mysql server, so you will be good to go with communicating mysql database with perl.
[reply]

Back to Seekers of Perl Wisdom