Re: Speaking of DBI -v- Net::MySQL (Was: RE: first dbi access with perl and lost)

2002-09-23 Thread Tatsuhiko Miyagawa
At Mon, 23 Sep 2002 22:35:03 -0500, Paul DuBois wrote: > DBI is useless without at least one driver for connecting to a specific > database. > > DBD:: is useless without DBI; Perl scripts don't communcate directly > with DBD drivers. They communicate with DBI, which speaks to the database > throu

Speaking of DBI -v- Net::MySQL (Was: RE: first dbi access with perl and lost)

2002-09-22 Thread Thoenen, Peter Mr. EPS
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/

Re: first dbi access with perl and lost

2002-09-22 Thread Paul DuBois
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

Re: first dbi access with perl and lost

2002-09-22 Thread Gerald Preston
Paul, Thank you!! I had installed DBD, but I did not know that I had to install DBD::mysql. THANKS SO MUCH!!! 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

Re: first dbi access with perl and lost

2002-09-22 Thread Paul DuBois
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

Re: first dbi access with perl and lost

2002-09-22 Thread Gerald Preston
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. Thanks, Jerry David Lloyd wrote: > Gerald, > > > Now I am getting the following: > > > > install_driver(mysql

Re: first dbi access with perl and lost

2002-09-22 Thread David Lloyd
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 f

Re: first dbi access with perl and lost

2002-09-22 Thread Gerald Preston
David, Thanks, 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? Thanks, Jerry David Lloy

Re: first dbi access with perl and lost

2002-09-22 Thread David Lloyd
Gerald, > #!perl > > use strict; > use DBI(); > > # Connect to the database. > my $dbh = DBI->connect("DBI:mysql:database=club;host=localhost", >"jwp", "x", > {'RaiseError' => 1}); > > $drh = DB

first dbi access with perl and lost

2002-09-22 Thread Gerald Preston
Hi!, I am lost! I am running in win 98 and my perl code is: #!perl use strict; use DBI(); # Connect to the database. my $dbh = DBI->connect("DBI:mysql:database=club;host=localhost", "jwp", "x", {'R