when i want to drop the database,the exception says that the
database is in use.but i check the connection state of the
database is close.So how to drop a database when the database is
in use by some thread?

dear friend: If u gonna drop ur DB from a program ensure its in use since u r connected to that! Perhabs u use an Adpter. When a software connect to DB it keeps connection till u quit the software, even see connection state is close!

HTH.

Always:),
Hovik Melkomian.

yes,at first the database can be dropped,but after i read or
write to the database(of course i have close the connectioin)
the database can't be dropped

dear friend if u think when u close ur DB-Conn its closed completely open a Profiler & test it. When u close still u have connection in ur profiler.

HTH.
I guess u can NOT Drop ur DB by App. & if its true, its good bc no1 is crasy (I dont mean anything) to drop DB by a App. u can do it Directly in DB side.

Always:),
Hovik Melkomian.

What sort of database are you trying to drop?

What do you mean by dropping the db? Are you trying to drop the connection or the database (ie delete it from the server?)

If you are doing the latter, then it probably failed because your drop db command requires an active connection to the db. You need to switch to another db before you can drop the db from the server.