Following this conversation myself (also a perl db newbie :) ... before always just used php) and curious if you know definitely what db vendor you are going to be using (mysql in this case), any reason to use dbi; as opposed to just using vendor specific or net::mysql; . Is it just a portability issue?
Cheers, -Peter > -----Original Message----- > From: Paul DuBois [mailto:[EMAIL PROTECTED]] > Sent: Sunday, September 22, 2002 21:35 > To: Gerald Preston > Cc: David Lloyd; mysql > Subject: Re: first dbi access with perl and lost > > > 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 <[EMAIL PROTECTED]> >> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >> >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 <[EMAIL PROTECTED]> >> To unsubscribe, e-mail <[EMAIL PROTECTED]> >> 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 <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
