can't install DBD::mysql under cygwin for mysql5

[tphyahoo]

I'm having an issue similar in spirit, if not in every detail, to that described in

http://www.cpanforum.com/posts/3561

(I actually actually tried posting at cpanforum first, but the cpanforum submission feature appears to be broken)

Basically, I followed the instructions for the cygwin install in the documentation at

http://search.cpan.org/src/RUDY/DBD-mysql-2.9008/INSTALL.html#windows_cygwin

*****************

UPDATE: that was for an old version of DBD::mysql. Maybe that was the problem. The newer version is at

DBD::mysql

stay tuned....

*****************

UPDATE: you can probably skip this next bit, as it refers to my attempt to follow the documentation in the out of date DBD::mysql.

Following this to the letter requires the source for mysql version 3.23.54a, which isn't even available any more from mysql.

http://downloads.mysql.com/archives.php?p=mysql-4.0

(they're not even allowing source downloads for mysql4 anymore.)

I attempted the install under cygwin with the latest mysql (mysql5). Makefile.PL went okay.

make failed with

hartman@ds0014 ~/.cpan/build/DBD-mysql-4.001
$ make
gcc -c  -I/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI -I/usr/local/my
+sql/include/mysql -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -DPERL_USE_SAFE_P
+UTENV -fno-
strict-aliasing -pipe -I/usr/local/include -DUSEIMPORTLIB -O3   -DVERS
+ION=\"4.001\" -DXS_VERSION=\"4.001\"  "-I/usr/lib/perl5/5.8/cygwin/CO
+RE"   dbdim
p.c
In file included from dbdimp.c:20:
dbdimp.h:23:45: mysqld_error.h: No such file or directory
dbdimp.c: In function `mysql_db_FETCH_attrib':
dbdimp.c:2319: warning: cast from pointer to integer of different size
dbdimp.c: In function `mysql_st_prepare':
dbdimp.c:2531: error: `ER_UNSUPPORTED_PS' undeclared (first use in thi
+s function)
dbdimp.c:2531: error: (Each undeclared identifier is reported only onc
+e
dbdimp.c:2531: error: for each function it appears in.)
dbdimp.c: In function `mysql_st_FETCH_attrib':
dbdimp.c:4148: warning: cast from pointer to integer of different size
make: *** [dbdimp.o] Error 1

*****************

UPDATE: okay, start reading again.

The current documentation of DBD::mysql suggests installation via ppm for win32.

I normally work under activestate, but in this case I thought cygwin would be better, because I had a script that needed to be modified to run on windows, and a number of dependency modules didn't compile easily under Active State to my recollection. So now, it seems I have everything working nicely under cygwin, except DBD::mysql, which I really need.

So, first question: given DBD::mysql installed via ppm, is there a way I can access this from a perl script run under cygwin?

Second question, barring that, has nyone been able to get DBD::mysql to work under cygwin for a recent version, or can point me to a way to download the old source? Or other constructive feedback?

Thanks in advance!