I am unable to get the perl to talk to the mysql.

I wrote an email to Jochen and he courtesouly and promptly replied. He asked me use this address and to be more specific about the errors I am seeing. A bit obvious I suppose.

I have been struggling with this for days and days;

John Brigham Denver, Colorado mrph...@juno.com

problems with MySQL. perl DBI DBD-Mysql

errors

c:\mysql\bin\mysqld.exe --console

gives error 30826 11:13:34 InnoDB: Operating system error number 32 in file operation. InnoDB: see http://www.innodb.com/ibman.html for installation help. Innodb: error number 32 means broken pipe Innodb: see also section 13.2 at http://www.innodb.com/ibman.html Innodb: about operating system error numbers Innodb: file name .\ibdata1 InnoDB: file operation call: 'open'. Innodb: cannot continue operation.

c:\mysql\bin\mysqld

works fine. sometimes this kills my DOS prompt and I have to open another command window. The mysql works fine and I am getting familiar with it.

work fine. I have been using it to see if the DBD-mysql is engaged.

#! /perl/bin/perl -w

use DBI;

my @drivers = DBI->available_drivers();

die "no drivers found!\n" unless @drivers;

foreach my $driver (@drivers){ print "Driver: $driver\n"; my @datasources = DBI->data_sources( $driver); foreach my $datasource ( @datasources ) { print "\tdata Source is $datasource\n"; } print "\n"; } exit;

I type c:\mysql\bin\wps\perl -w whatdbd.pl

and get

Driver: ExampleP data source is dbi:Examplep:dir=.

Driver:proxy install_driver (proxy)failed: can't locate RPC/Plclient.pm in @inc (@inc contains: E:/perl/lib E:/perl/site/lib .) at E:/perl/site/lib/DBD/proxy.pm line 28. BEGIN failed--compilation aborted at E:/perl/site/lib/DBD/Proxy.pm line 28. Compliation failed in require at (eval 2) line 3. Perhaps a module that DBD::Proxy requires hasn't been fully installed at whatdbd.pl line 11

tried endless variations to no avail.

#! /usr/bin/perl -w

use DBI;

$database="meetageek"; $driver = "DBI:mysql"; my $dbh = DBI->connect($driver:database=$database, "root","mrphysh") or die "cannot connect";

#insert the values $dbh->do("INSERT INTO Customers (First_Name,Last_Name) VALUES ('Rene','Robertson')"); $dbh->do("INSERT INTO Customers (First_Name,Last_Name) VALUES ('Larry','Isaacson')"); $dbh->do("INSERT INTO Customers (First_Name,Last_Name) VALUES ('Mark','Harrison')");

#Dissconnect from Database

$dbh ->disconnect;

This is typical of the error I see:

Unquoted string "database" may clash with future reserved word at firstscript line 7. syntax error at firstscript.pl line 7 near "$driver:" execution of firstscript.pl aborted due to compilation errors.

#! /usr/bin/perl -w

use DBI;

$database="meetageek"; $driver = "DBI:mysql"; my $dbh = DBI->connect("DBI::mysql:meetageek","root","myphysh") ;

#insert the values $dbh->do (INSERT INTO Customers VALUES 'Rene','Robertson');

#Dissconnect from Database

$dbh ->disconnect;

it gives this error: name "main::database" used only once: possilbe typo at 5script.pl line 5. name "main::driver" used only once: possible typo at 5script.pl line 6. Can't connect (DBI::mysql:meetageek root mrphysh), no database driver specified and DBI_)DSN env var not set at 5script.pl line7.

xxxxxxxxxxxxxxxxxxxxx I have tried reloading all the software. I have tried different ppm packages. I have endlessly used ppm to install and uninstall.

I have Active perl version 1.37 5.8.0.806MySQL version 4.0.14

windows 2000 pentium II 256 RAM My compac has an E: drive and the perl seems to install there by default.

I am committed to this and stuck!