Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Get number of licensed users on network database server

3 posts in General Discussion Last posting was on 2003-08-21 08:12:11.0Z
Erik Huisman Posted on 2003-08-20 14:49:30.0Z
From: "Erik Huisman" <erik.huisman@spam.ishbv.com.no>
Newsgroups: ianywhere.public.general
Subject: Get number of licensed users on network database server
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
X-Original-NNTP-Posting-Host: p30113.net.upc.nl
Message-ID: <3f438a92@forums-2-dub>
X-Original-Trace: 20 Aug 2003 07:49:54 -0700, p30113.net.upc.nl
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 20 Aug 2003 07:48:42 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 20 Aug 2003 07:49:30 -0700
X-Trace: forums-1-dub 1061390970 10.22.108.75 (20 Aug 2003 07:49:30 -0700)
X-Original-Trace: 20 Aug 2003 07:49:30 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1637
Article PK: 3862

Hello,

Is there a sql statement to retreive the number of licensed users on a
network database server (set with dblic.exe).
select @@max_connections is not the right command.

We are using ASA 6.0.3 (are currently also testing ASA 9)

Erik


Chris Keating (iAnywhere Solutions) Posted on 2003-08-20 15:06:19.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <3f438a92@forums-2-dub>
Subject: Re: Get number of licensed users on network database server
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: keating-xp.sybase.com
Message-ID: <3f438e83$1@forums-2-dub>
X-Original-Trace: 20 Aug 2003 08:06:43 -0700, keating-xp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 20 Aug 2003 08:05:31 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 20 Aug 2003 08:06:19 -0700
X-Trace: forums-1-dub 1061391979 10.22.108.75 (20 Aug 2003 08:06:19 -0700)
X-Original-Trace: 20 Aug 2003 08:06:19 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1639
Article PK: 3864

See server properties in the help. The specific query is

select db_property ('LicenseCount' )

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

Sybase TechWave User Training and Solutions conference -- August 4 - 8, 2003
in Orlando, FL. -- A great place for education and in-depth discussions
on all our technology, future trends in the market, not to mention getting
time with the engineers who create the products! For more information,
visit http://www.ianywhere.com/techwave2003

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

"Erik Huisman" <erik.huisman@spam.ishbv.com.no> wrote in message
news:3f438a92@forums-2-dub...
> Hello,
>
> Is there a sql statement to retreive the number of licensed users on a
> network database server (set with dblic.exe).
> select @@max_connections is not the right command.
>
> We are using ASA 6.0.3 (are currently also testing ASA 9)
>
> Erik
>
>
>
>


Erik Huisman Posted on 2003-08-21 08:12:11.0Z
From: "Erik Huisman" <erik.huisman@spam.ishbv.com.no>
Newsgroups: ianywhere.public.general
References: <3f438a92@forums-2-dub> <3f438e83$1@forums-2-dub>
Subject: Re: Get number of licensed users on network database server
Lines: 54
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: p30113.net.upc.nl
X-Original-NNTP-Posting-Host: p30113.net.upc.nl
Message-ID: <3f447edb@forums-1-dub>
Date: 21 Aug 2003 01:12:11 -0700
X-Trace: forums-1-dub 1061453531 212.142.30.113 (21 Aug 2003 01:12:11 -0700)
X-Original-Trace: 21 Aug 2003 01:12:11 -0700, p30113.net.upc.nl
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1644
Article PK: 3868

Thanks for the information Chris,

The query should be
select property('LicenseCount')

This property is not available in ASA 6.0.3 but is available in version 9.

Erik

"Chris Keating (iAnywhere Solutions)" <FightSpam_keating@iAnywhere.com>

wrote in message news:3f438e83$1@forums-2-dub...
> See server properties in the help. The specific query is
>
> select db_property ('LicenseCount' )
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
> Sybase TechWave User Training and Solutions conference -- August 4 - 8,
2003
> in Orlando, FL. -- A great place for education and in-depth discussions
> on all our technology, future trends in the market, not to mention getting
> time with the engineers who create the products! For more information,
> visit http://www.ianywhere.com/techwave2003
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use CaseXpress to report bugs http://casexpress.sybase.com
>
> "Erik Huisman" <erik.huisman@spam.ishbv.com.no> wrote in message
> news:3f438a92@forums-2-dub...
> > Hello,
> >
> > Is there a sql statement to retreive the number of licensed users on a
> > network database server (set with dblic.exe).
> > select @@max_connections is not the right command.
> >
> > We are using ASA 6.0.3 (are currently also testing ASA 9)
> >
> > Erik
> >
> >
> >
> >
>
>