List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 22 2002 7:35pm
Subject:Re: first dbi access with perl and lost
View as plain text  
At 14:24 -0500 9/22/02, Gerald Preston wrote:
>Paul,
>
>Thank you!!  I had installed DBD, but I did not know that I had to 
>install DBD::mysql.
>
>THANKS SO MUCH!!!

I take it from your tone that your script works now? :-)

DBI (I assume that's what you mean by "installing DBD", because there is no
"DBD" module as such) provides the top-level database access mechanism.
But it doesn't contain any information about specific databases, so
you need to install a driver for each type of database you want to access:
DBD::mysql for MySQL, DBD::Pg for PostgreSQL, etc.  DBI uses the DBD-level
drivers to communicate with specific types of database servers.

>
>Jerry
>
>Paul DuBois wrote:
>
>>  At 13:33 -0500 9/22/02, Gerald Preston wrote:
>>  >David,
>>  >
>>  >I am not getting any where..........   Do I have create mysql.pm on
>>  >my system or can just copy the file onto my system.
>>  >I do not understand why MySQL did not create this file.
>>
>>  Because it's not part of MySQL.  It's part of DBD::mysql, the MySQL-specific
>>  driver for the DBI module.
>>
>>  Since you say you're not getting anywhere, but do not specify what you've
>>  tried, all we can say is follow the directions you've already been given.
>>  That is, use ppm to install the DBD::mysql module.
>>
>>  Invoke the ppm program, then run this command:
>>
>>  install DBD::mysql
>>
>>  >Thanks,
>>  >
>>  >Jerry
>>  >
>>  >David Lloyd wrote:
>>  >
>>  >>  Gerald,
>>  >>
>>  >>  > Now I am getting the following:
>>  >>  >
>>  >>  > install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC
>>  >>contains; C:/Perl/lib C:/Perlsite/lib .) at (eval 1)
>>  >>  > line 3;
>>  >>  >
>>  >>  > I can't mysql.pm on my PC.  Was it not generated when I
>>  >>installed MySQL?  How do I fix this?
>>  >>
>>  >>  No, it's separate from the distribution of MySQL.
>>  >>
>>  >>  If you're using ActiveState then start the "ppm" (Perl Package
> Manager
>>  >>  Utility) and look for:
>>  >>
>>  >>    DBD::mysql
>>  >>
>>  >>  You'll find it here:
>>  >>
>>  >>    * http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?request=search
>>  >>
>>  >>    (Search for DBD::mysql)
>>  >>
>>  >>  I don't really know the best way to install Perl modules on Windows
> (I
>>  >>  avoid Windows like the plague).
>>  >>
>>  >>  DSL
>>  >>  --
>>  >>  I reniad lin ne mor, nuithannen
>>  >>    In gwidh ristennin, i fae narchannen
>>  >>  I lach Anor ed ardhon gwannen
>>  >>    (Soundtrack LOTR)
>>  >
>>  >
>>  >
>>  >---------------------------------------------------------------------
>>  >Before posting, please check:
>>  >    http://www.mysql.com/manual.php   (the manual)
>>  >    http://lists.mysql.com/           (the list archive)
>>  >
>>  >To request this thread, e-mail <mysql-thread120249@stripped>
>>  >To unsubscribe, e-mail
> <mysql-unsubscribe-paul=snake.net@stripped>
>>  >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>>  ---------------------------------------------------------------------
>>  Before posting, please check:
>>     http://www.mysql.com/manual.php   (the manual)
>>     http://lists.mysql.com/           (the list archive)
>>
>>  To request this thread, e-mail <mysql-thread120250@stripped>
>>  To unsubscribe, e-mail <mysql-unsubscribe-jwp=ont.com@stripped>
>>  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread120251@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
first dbi access with perl and lostGerald Preston22 Sep
  • Re: first dbi access with perl and lostDavid Lloyd22 Sep
  • Re: first dbi access with perl and lostGerald Preston22 Sep
  • Re: first dbi access with perl and lostDavid Lloyd22 Sep
  • What's this error mean?Randy Johnson22 Sep
    • Re: What's this error mean?Duncan Hill22 Sep
  • Re: first dbi access with perl and lostGerald Preston22 Sep
    • Re: first dbi access with perl and lostPaul DuBois22 Sep
  • Re: first dbi access with perl and lostGerald Preston22 Sep
    • Re: first dbi access with perl and lostPaul DuBois22 Sep
      • Documentation correction...Jon Frisby23 Sep
        • RE: Documentation correction...Jon Frisby23 Sep