Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Drop Table with FoxPro and "File is use " error message

843854Jul 16 2003 — edited Jul 30 2003
Hello,
I'm developing a program which connects to an existing database that has been made with Visual FoxPro.

Everything is ok, but when I try to do a DROP TABLE of a table that I have just accessed before with a SELECT statement, I get an SQLException :

java.sql.SQLException: [Microsoft][ODBC Visual FoxPro Driver]File is in use.


I have, of course, made a close() after the SELECT.
No other programs/table is using this table.

Does anybody have an idea ?

Thanks for any answer.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2003
Added on Jul 16 2003
#java-database-connectivity-jdbc
1 comment
325 views