connections and isql

Thread View: borland.public.interbase.opensource

6 messages

[T] Back to Threads [V] Tree View [G] Group Articles

6 total messages Started by FrankW Wed, 10 Aug 2005 13:43

#127

Author: FrankW
Date: Wed, 10 Aug 2005 13:43

6 lines
989 bytes

Hi,

is there a way to know how many connections made to a gdb using isql?
thanks.

frank

Re: connections and isql

#128

Author: Bill Todd
Date: Wed, 10 Aug 2005 14:33

4 lines
995 bytes

SELECT COUNT(*) FROM RDB$ATTACHMENTS

-- 
Bill Todd (TeamB)

Re: connections and isql

#129

Author: Craig Stuntz TeamB
Date: Wed, 10 Aug 2005 15:06

11 lines
1361 bytes

Bill Todd wrote:

> SELECT COUNT(*) FROM RDB$ATTACHMENTS

	That's TMP$ATTACHMENTS.

-- 
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
How to ask questions the smart way:
  http://www.catb.org/~esr/faqs/smart-questions.html

Re: connections and isql

#131

Author: Craig Stuntz TeamB
Date: Wed, 10 Aug 2005 15:06

7 lines
1373 bytes

	...oh, and you'll probably want to exclude the COLLECTOR attachment.

-- 
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
All the great TeamB service you've come to expect plus (New!) 
  Irish Tin Whistle tips: http://learningtowhistle.blogspot.com

Re: connections and isql

#130

Author: Craig Stuntz TeamB
Date: Wed, 10 Aug 2005 15:07

11 lines
1565 bytes

	...oh, and I just noticed we're in the .opensource group, so you can't
do any of this with 6.0 anyway.

	You can get the user count with 6.0 using TIBDatabaseInfo, but I don't
know how to do it with ISQL.

-- 
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
All the great TeamB service you've come to expect plus (New!) 
  Irish Tin Whistle tips: http://learningtowhistle.blogspot.com

Re: connections and isql

#132

Author: Bill Todd
Date: Wed, 10 Aug 2005 15:30

4 lines
1034 bytes

I guess I  need to go back to bed.:(

-- 
Bill Todd (TeamB)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads