Errors/Warning with Connect using DBI/DBD::MySQL under Win32 (ActiveState)

Errors/Warning with Connect using DBI/DBD::MySQL under Win32 (ActiveState)

am 13.10.2004 21:23:24 von Robert Berman

Using the ActiveState Win32 DBI/DBD::MySQL module (Version 2.9003) I get
the following errors when I connect in my perl program, test.pl:

use DBI;
use DBD::mysql;

my ($dbh);

$dbh = DBI->connect("DBI:mysql:Aggregate", 'root', undef);

if (! $dbh) {
print "Unable to connect to Aggregate DB.\n";
}
else {
$dbh->disconnect;
}

perl test.pl
File 'C:\mysql\\share\charsets\?.conf' not found (Errcode: 22)
Character set '#33' is not a compiled character set and is not specified
in the 'C:\mysql\\share\charsets\Index' file

I am connecting to MySQL 4.1.4-gamma-max which supports utf8. I have the
entry

[mysqld]
default-character-set = utf8

in the my.ini file. If I remove the entry, the errors go away, but my
application uses utf8 data! Running the same program from Linux to the
Win32 MySQL server works fine. MySQL tech support suggested that
DBD::MySQL might not be compiled for version 4.1 since the charsets file
is called "Index.xml" in 4.1, not just "Index" as in previous versions.

Any help will be appreciated.

Robert Berman


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org