At 11:06 AM 8/10/2004 +0000, you wrote:

>I'm having a problem with Firebird 1.5.1 on Windows 98. I have a
>script to update my database, which I run in my customers. This
>script is something like this:
>
>DROP PROCEDURE INS_EMPLOYEES;
>DROP PROCEDURE UPD_EMPLOYEES;
>DROP TABLE EMPLOYEES;
>
>I'm droping the related procedures to the table EMPLOYEES and then
>droping the table EMPLOYEES. This script runs fine in Windows XP,
>but in Windows 98 it returns this message: "Table EMPLOYEES is in
>use".
>
>Why does this problem just occur in Windows98???? I've also tryied
>to put a COMMIT between the statements unsuccessfully.

If the procedures have been run since the server application started
running, they will be cached. When they are cached, you can't drop them,
because they are "in use".

When running the server as a service, the server is in a "shutdown" state
when all users log out. This frees SPs from the cache (I think!) The
Sysdba or Owner can then log in with exclusive access and drop the SP.

On Win98, there are no services. The server runs as an application, which
means you will have to stop and restart it to clear the cache. You can
only do this from the system tray....at least, I don't know of any way to
stop it from the command line.

I won't answer support questions off-list, so please don't send them. The
reason you are having trouble posting to the list is probably that you are
using the wrong Sender address. You must post using
<giovanibettiol@...> because this is the address you are subscribed
under.

./heLen