Funny, someone cross posted my question. I didn't even know this list
existed until a few minutes ago when I was reading my email on the
Mentioned OS X forum. What a supprise to find people already discussing
my problem when I join up.
Any way...
> Someone posted the question below to an OSX forum and another person
> suggested asking this group the same question. At the risk of possibly
> being
> redundant, I too will ask the question so that I may find out what is
> wrong.
> For, I too am having the same difficulty.
>
> I have installed all the parts, mysql ( which is running and I have a
> test database running on it with a few rows ), DBI, and DBD::MySql.
>
> But when I run my perl program I get the following error:
>
> [localhost:~/src/perl] dwalker% ./mysqltest.pl
>
please post some of the mysqltest.pl code
Here it is:
------
#!/usr/bin/perl
# use strict;
use DBI();
$dbh = DBI->connect('DBI:mysql:test', 'root', 'audis8');
if ( not $dbh ) { die "Connect Failed: $DBI::errstr\n"; }
$drh = DBI ->install_driver("mysql");
my $qstr = "SELECT * FROM testola";
print "$qstr\n";
my $out = $dbh->prepare("$qstr");
$out->execute;
while (($data1,$data2)=$out->fetchrow_array) {
print "$data1\t$data2\n";
}
-----
And the DB contains:
----
mysql> select * from testola;
+--------+---------+
| one | two |
+--------+---------+
| 666 | Derrik |
| 777 | Kathy |
| 111 | 3p0 |
| 999 | Ktulu |
+--------+---------+
4 rows in set (0.29 sec)
mysql>
-----
Thanks.
- Derrik
[EMAIL PROTECTED]
http://junior.apk.net/~firebug
---------------------------------------------------------------------------------------------------
I got the computer telling me we need disk, I got management saying.
"no!" Well eventually the computer will win... They always do.
