Re: An error (hhctrl.ocx) and a bug (DROP DB)

> -----Original Message-----
> From: Çagil Seker [mailto:cagils(at)biznet(dot)com(dot)tr]
> Sent: 28 November 2002 10:16
> To: PGAdmin-Support-List (E-mail)
> Subject: [pgadmin-support] An error (hhctrl.ocx) and a bug (DROP DB)
>
>
>
> On the installation of pgAdmin (.. 1.4.0 - 1.4.1. - 1.4.2) I
> get en error about hhctrl.ocx. But after I click OK the
> installation goes without error. The error is "Error 1931:
> The windows intaller service cannot update the system file
> C:\WINNT\System32\hhctrl.ocx because the fle is protected by
> Windows. You may need to update your operating system for
> this program to work correctly." I don't think this is a bug
> anyway I wanted to state it.

No, it's not a bug.

> The real issue comes with the 1.4.2 (I don't remember getting
> this error apriori). I cannot drop the databases I've
> created. I get two different errors. I couldn't figure out on
> what conditions one or other appears. The errors are:
>
> "An error has occured in pgAdmin II:basActions.Drop:
> Number: -2147467259
> Description: ERROR: DROP DATABASE: database "test" is being
> accessed by other users"
>
> "An error has occured in pgAdmin II:basActions.Drop:
> Number: 424
> Description: Object required"
>
> I am sure that no one accesses the databases while I drop
> them. These errors don't affected by number of tables, or not
> having any at all.
>
> Is this a bug or am I doing something wrong?

It is a bug, but it is related to the way Microsoft ADO opens database connections (ie. It doesn't close them immediately) and has *always* existed. For more info, look at the bottom of http://www.pgadmin.org/pgadmin2.php?ContentID=5

Regards, Dave.