Hello again I had previously reported problems with the DBI/DBD:mysql interface on these lists where queries would fail for an enumerated variable out of range and for DBD::mysql tests failing on transaction support. An asute member of the ensembl list pointed out a possible issue with 32bit integers, and I suspect the same problem was true for a flag for transaction support with DBD tests. I really needed mysql, so I obtained the mysql 5.0.22 rpms (server/client/libs/dev) for x86_64 and installed them. I then cleaned and reinstalled DBI and DBD::mysql and now DBD passes its tests and my existing perl scripts work. Whatever problem I had was fixed by the latest mysql release. The server rpm wanted a DBI rpm to be installed first and recommended v1.40 x86_64 which I installed. I don't know if this recommendation was built into the rpm or came from the RH 4 system. I installed DBI 1.51 anyway, and the DBD install from source said it was using the latter. It works, so I guess the 1.40 rpm was not an issue.
Thanks to all that helped. Cheers Mike
