RE: can't DROP tables

2003-03-07 Thread Jeff Urlwin
> > I am using ActivePerl 5.8 and DBD::ODBC, ODBC is connecting > to Microsoft Access Driver. > > At the end of my Perl program, I want to DROP all tables just > created for tempory use. However, it caused error. The error > message is about " the table xxx is being used by other > applicatio

Re: can't DROP tables

2003-03-06 Thread Paul Boutros
Try closing all statement-handles that touch those tables first. i.e. $sth->close(); On Fri, 7 Mar 2003, [big5] Gary Fung wrote: > > I am using ActivePerl 5.8 and DBD::ODBC, ODBC is connecting to Microsoft Access > Driver. > > At the end of my Perl program, I want to DROP all tables just crea

can't DROP tables

2003-03-06 Thread Gary Fung
I am using ActivePerl 5.8 and DBD::ODBC, ODBC is connecting to Microsoft Access Driver. At the end of my Perl program, I want to DROP all tables just created for tempory use. However, it caused error. The error message is about " the table xxx is being used by other applications " ( I just