> > Same env as before. > > After running the test, I find I can't delete the table perl_dbd_test > from the db test. > > A little program with > my($sql) = 'drop table perl_dbd_test'; > my($sth) = $dbh -> do($sql); > outputs: > Error: DBD::mysql::db do failed: Error on delete of > '.\test\perl_dbd_test.MYI' (Errcode: 13). > > Have you seen this error? > > I've just had a look at the MySQL manual (corresponding to V 3.23.51 > I'd say) and can not see any such error discussed in Appendix A. > > I have to stop and restart the server before the drop works. > > I'm not suggesting this is due to DBD::ODBC, although I suppose > anything's possible. I assume it is due to the version of MySQL I'm > using. > > Any ideas?
Nope -- not on this, but this is what's causing the error in the test you reported earlier. Sorry -- I test with Oracle, SQL Server (2000), DB2 and Access. I don't normally test with MySQL. I can suggest a few things: 1) DBD::ODBC may very well work, depending upon the complexity of your applications...but you may run into problems as things get more complex. 2) Did you try DBD::MySQL? Regards, Jeff
