Hi, > -----Original Message----- > From: Fabrice Schleifer [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 20, 2002 11:31 PM > To: [EMAIL PROTECTED] > Subject: MyODBC Blocking Table for DROP request ? > > > Hello everybody, > > here is a strange thing that creates me nightmares ... > > How-To-Repeat: > > Stage 1 . Using a my SQL GUI : > > Create a simple Table ... > > create table FAKE (bidon integer) > > Everything works fine ... > > > Stage 2. Using a C compiler and MyODBC3.51 Driver (actually I use > Borland as > C Compiler) > > << cut >> > > > Everything successes in this code , always SQL Success is returned > ( note: I removed the lines that use the result set of > SQLColumns.. because > of no interest ..) > > > Stage 3. Using the GUY , try to erase the table ... > > DROP table FAKE > > Message : Error on delete of '.\LemoineDB\fake.MYI' (Errcode: 13) > (I think > this is an permission problem) > > I am almost sure I habe all the permissionss : > I cannot succeed in deleting the table until I stop the server and restart > it . > Once the server is restarted I can drop the table using the command above > with no problem . > Other test I did : If I comment out the SQLColumns API , everything works > fines from stage 1 to 3 . > > > Fix: > > > I have to restart the server to drop the tables ..(that not a fix > ) :--))) > > > See also information below and joined the MyODBC.log I created running the > code . > > Please , give me a quick answer even if no quick solution .
I could able to reproduce the bug, and will fix it for the next release versions by finding the exact cause (possibly some where we are not closing the opened session while using the mysql_list_fields()). The immediate work around is to execute "FLUSH TABLES" before you try to drop it, that way you can eliminate the server shutdown. And, thanks for the good functionality bug. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
