Re: dropping interbase connection

I didn't try it, but I suspect:

update tmp$attachments set tmp$state='CANCEL';

For more information see chapter 9 of the Operations Guide Manual.

Luca Gallo (Gmg Sistemi) wrote:
> Hi all,
> 
> I need a way to drop some existings connection to an interbase DB,
> i've seen (IB7.5 and 2007) that i can see wich connection is live with this

> query
> 
> SELECT * FROM TMP$ATTACHMENTS
> 
> Since I need to disconnect all users to make some metadata change in an 
> application upgrade process
> I'm looking for a way to do that inside a Delphi application (maybe IBX 
> provide some methods to do that ?)
> 
> I've seen that Interbase Performance Monitor has the ability to do that and

> I hope it is written in Delphi
> 
> TIA
> 

Quinn Wildman (CodeGear Developer Support) wrote:

> update tmp$attachments set tmp$state='CANCEL';

	Set the state to SHUTDOWN

	Yes, Performance Monitor is written in Delphi.

-- 
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Want to help make Delphi and InterBase better?  Use QC!

'SHUTDOWN', not 'CANCEL'

-- 

Hi all,

I need a way to drop some existings connection to an interbase DB,
i've seen (IB7.5 and 2007) that i can see wich connection is live with this 
query

SELECT * FROM TMP$ATTACHMENTS

Since I need to disconnect all users to make some metadata change in an 
application upgrade process
I'm looking for a way to do that inside a Delphi application (maybe IBX 
provide some methods to do that ?)

I've seen that Interbase Performance Monitor has the ability to do that and 
I hope it is written in Delphi

TIA


-- 
===================================================
Luca Gallo
Resp. Area Innovazione Software

GMG SISTEMI SRL
Via Belluno, 43-45
30035 Mirano (VE)
e-mail: luca.gallo@gmgsistemi.it
Tel.: 041/5703131 (r.a.)
Fax:  041/5703006
===================================================
INFORMAZIONI STRETTAMENTE CONFIDENZIALI: L'invio di questa e-mail è 
destinato solo ad uso personale o a enti sopra nominati e potrebbe contenere 
informazioni riservate, coperte da segreto professionale, e non soggette a 
divulgazione ai sensi di legge. Se non ne siete i corretti destinatari, con 
la presente siete informati che non vi è assolutamente permessa alcuna 
divulgazione, copia, distribuzione, o altro uso delle informazioni in essa 
contenute. Se per errore avete ricevuto questo messaggio, Vi chiedo 
cortesemente di informarci immediatamente al nostro indirizzo di posta 
elettronica. Grazie 

Luca Gallo (Gmg Sistemi) wrote:

> have you written something like that for IB 2007 ?

No.

--