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.

Concurrent User control

23 posts in Commercial ISV's Last posting was on 2009-02-06 15:54:28.0Z
Victor Hernandez Posted on 2008-02-15 21:49:37.0Z
From: "Victor Hernandez" <vhernandez@innova.com.mx>
Newsgroups: sybase.public.commercial-isv.general
Subject: Concurrent User control
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47b608f1$1@forums-1-dub>
Date: 15 Feb 2008 13:49:37 -0800
X-Trace: forums-1-dub 1203112177 10.22.241.152 (15 Feb 2008 13:49:37 -0800)
X-Original-Trace: 15 Feb 2008 13:49:37 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:54
Article PK: 103777

We are developing an application and we want to control concurrent users
accessing it. we're using PowerBuilder 9, SQLServer 2005/2000, sybase 9 and
oracle 8/9

Is there any way I may know how many concurrent users are accessing my
application running on sybase, microsoft sql or oracle?


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-02-15 22:15:21.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.commercial-isv.general
References: <47b608f1$1@forums-1-dub>
Subject: Re: Concurrent User control
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47b60ef9$1@forums-1-dub>
Date: 15 Feb 2008 14:15:21 -0800
X-Trace: forums-1-dub 1203113721 10.22.241.152 (15 Feb 2008 14:15:21 -0800)
X-Original-Trace: 15 Feb 2008 14:15:21 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:55
Article PK: 103776

In Oracle, Select count(*) from v$_session where program='yourapp.exe'.

"Victor Hernandez" <vhernandez@innova.com.mx> wrote in message
news:47b608f1$1@forums-1-dub...
>
> We are developing an application and we want to control concurrent users
> accessing it. we're using PowerBuilder 9, SQLServer 2005/2000, sybase 9
> and oracle 8/9
>
> Is there any way I may know how many concurrent users are accessing my
> application running on sybase, microsoft sql or oracle?
>


Mark K Posted on 2008-02-16 04:40:54.0Z
From: "Mark K" <xxxx>
Newsgroups: sybase.public.commercial-isv.general
References: <47b608f1$1@forums-1-dub>
Subject: Re: Concurrent User control
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47b66956$1@forums-1-dub>
Date: 15 Feb 2008 20:40:54 -0800
X-Trace: forums-1-dub 1203136854 10.22.241.152 (15 Feb 2008 20:40:54 -0800)
X-Original-Trace: 15 Feb 2008 20:40:54 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:56
Article PK: 103778

In ASE:
select count(*) from master..sysprocesses where program_name = '<your
program>'

Mark Kusma

"Victor Hernandez" <vhernandez@innova.com.mx> wrote in message
news:47b608f1$1@forums-1-dub...
>
> We are developing an application and we want to control concurrent users
> accessing it. we're using PowerBuilder 9, SQLServer 2005/2000, sybase 9
> and oracle 8/9
>
> Is there any way I may know how many concurrent users are accessing my
> application running on sybase, microsoft sql or oracle?
>


M. Searer Posted on 2008-02-17 16:40:24.0Z
From: "M. Searer" <nospam@nospam.com>
Newsgroups: sybase.public.commercial-isv.general
References: <47b608f1$1@forums-1-dub> <47b66956$1@forums-1-dub>
Subject: Re: Concurrent User control
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47b86378$1@forums-1-dub>
Date: 17 Feb 2008 08:40:24 -0800
X-Trace: forums-1-dub 1203266424 10.22.241.152 (17 Feb 2008 08:40:24 -0800)
X-Original-Trace: 17 Feb 2008 08:40:24 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:58
Article PK: 103780

and Same for MS SQL

select * from master.dbo.sysprocesses where program_name = '<your program>'

"Mark K" <xxxx> wrote in message news:47b66956$1@forums-1-dub...
> In ASE:
> select count(*) from master..sysprocesses where program_name = '<your
> program>'
>
> Mark Kusma
>
> "Victor Hernandez" <vhernandez@innova.com.mx> wrote in message
> news:47b608f1$1@forums-1-dub...
>>
>> We are developing an application and we want to control concurrent users
>> accessing it. we're using PowerBuilder 9, SQLServer 2005/2000, sybase 9 and
>> oracle 8/9
>>
>> Is there any way I may know how many concurrent users are accessing my
>> application running on sybase, microsoft sql or oracle?
>>
>
>


Breck Carter [sqlanywhere.blogspot.com] Posted on 2008-02-16 13:45:28.0Z
From: "Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: sybase.public.commercial-isv.general
Subject: Re: Concurrent User control
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com>
References: <47b608f1$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 16 Feb 2008 05:45:28 -0800
X-Trace: forums-1-dub 1203169528 10.22.241.152 (16 Feb 2008 05:45:28 -0800)
X-Original-Trace: 16 Feb 2008 05:45:28 -0800, vip152.sybase.com
Lines: 23
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:57
Article PK: 103779

If by "sybase 9" you mean SQL Anywhere:

SELECT COUNT(*) FROM sa_conn_info();

Breck

On 15 Feb 2008 13:49:37 -0800, "Victor Hernandez"

<vhernandez@innova.com.mx> wrote:

>
>We are developing an application and we want to control concurrent users
>accessing it. we're using PowerBuilder 9, SQLServer 2005/2000, sybase 9 and
>oracle 8/9
>
>Is there any way I may know how many concurrent users are accessing my
>application running on sybase, microsoft sql or oracle?
>

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com


Victor Hernandez Posted on 2008-02-18 17:33:45.0Z
From: "Victor Hernandez" <vhernandez@innova.com.mx>
Newsgroups: sybase.public.commercial-isv.general
References: <47b608f1$1@forums-1-dub> <mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com>
Subject: Re: Concurrent User control
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47b9c179$1@forums-1-dub>
Date: 18 Feb 2008 09:33:45 -0800
X-Trace: forums-1-dub 1203356025 10.22.241.152 (18 Feb 2008 09:33:45 -0800)
X-Original-Trace: 18 Feb 2008 09:33:45 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:61
Article PK: 103783

Is there anyway to know the user names of who are connected to the database?

"Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__bcarter@risingroad.com>

wrote in message news:mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com...
> If by "sybase 9" you mean SQL Anywhere:
>
> SELECT COUNT(*) FROM sa_conn_info();
>
> Breck
>
> On 15 Feb 2008 13:49:37 -0800, "Victor Hernandez"
> <vhernandez@innova.com.mx> wrote:
>
>>
>>We are developing an application and we want to control concurrent users
>>accessing it. we're using PowerBuilder 9, SQLServer 2005/2000, sybase 9
>>and
>>oracle 8/9
>>
>>Is there any way I may know how many concurrent users are accessing my
>>application running on sybase, microsoft sql or oracle?
>>
>
> --
> Breck Carter http://sqlanywhere.blogspot.com/
>
> RisingRoad SQL Anywhere and MobiLink Professional Services
> breck.carter@risingroad.com


Breck Carter [sqlanywhere.blogspot.com] Posted on 2008-02-18 19:32:30.0Z
From: "Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: sybase.public.commercial-isv.general
Subject: Re: Concurrent User control
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com>
References: <47b608f1$1@forums-1-dub> <mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com> <47b9c179$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 18 Feb 2008 11:32:30 -0800
X-Trace: forums-1-dub 1203363150 10.22.241.152 (18 Feb 2008 11:32:30 -0800)
X-Original-Trace: 18 Feb 2008 11:32:30 -0800, vip152.sybase.com
Lines: 58
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:62
Article PK: 103786

Oh, yes, sa_conn_info() returns many interesting values...

SELECT * FROM sa_conn_info();
Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
2,'ddd-1','DBA',0,'2008-02-18
14:29:06.519',,,'CURSOR_FETCH','local','',800,,0,0,0
1,'ddd-2','DBA',0,'2008-02-18
14:28:51.799',,,'CURSOR_CLOSE','local','',0,,0,0,0

The Userid column is probably what you want.

The Name is the "CON" connection name connection string parameter that
is often empty but it's there for you to fill in in the connection
string if you need some value other than user id.

There are many other connection-level properties available via calls
to CONNECTION_PROPERTY().

Breck.

On 18 Feb 2008 09:33:45 -0800, "Victor Hernandez"

<vhernandez@innova.com.mx> wrote:

>Is there anyway to know the user names of who are connected to the database?
>
>"Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__bcarter@risingroad.com>
>wrote in message news:mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com...
>> If by "sybase 9" you mean SQL Anywhere:
>>
>> SELECT COUNT(*) FROM sa_conn_info();
>>
>> Breck
>>
>> On 15 Feb 2008 13:49:37 -0800, "Victor Hernandez"
>> <vhernandez@innova.com.mx> wrote:
>>
>>>
>>>We are developing an application and we want to control concurrent users
>>>accessing it. we're using PowerBuilder 9, SQLServer 2005/2000, sybase 9
>>>and
>>>oracle 8/9
>>>
>>>Is there any way I may know how many concurrent users are accessing my
>>>application running on sybase, microsoft sql or oracle?
>>>
>>
>> --
>> Breck Carter http://sqlanywhere.blogspot.com/
>>
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> breck.carter@risingroad.com
>

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com


Victor Hernandez Posted on 2008-02-19 15:59:16.0Z
From: "Victor Hernandez" <vhernandez@innova.com.mx>
Newsgroups: sybase.public.commercial-isv.general
References: <47b608f1$1@forums-1-dub> <mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com> <47b9c179$1@forums-1-dub> <k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com>
Subject: Re: Concurrent User control
Lines: 67
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47bafcd4$1@forums-1-dub>
Date: 19 Feb 2008 07:59:16 -0800
X-Trace: forums-1-dub 1203436756 10.22.241.152 (19 Feb 2008 07:59:16 -0800)
X-Original-Trace: 19 Feb 2008 07:59:16 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:63
Article PK: 103784

Is there a way a function in powerbuilder 9.0 (code or syntax) to disconnect
users from the database remotely for (sybase 9.0 (sql anywhere),sqlserver
and oracle 8.0/9.0)?

"Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>

wrote in message news:k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com...
> Oh, yes, sa_conn_info() returns many interesting values...
>
> SELECT * FROM sa_conn_info();
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 2,'ddd-1','DBA',0,'2008-02-18
> 14:29:06.519',,,'CURSOR_FETCH','local','',800,,0,0,0
> 1,'ddd-2','DBA',0,'2008-02-18
> 14:28:51.799',,,'CURSOR_CLOSE','local','',0,,0,0,0
>
> The Userid column is probably what you want.
>
> The Name is the "CON" connection name connection string parameter that
> is often empty but it's there for you to fill in in the connection
> string if you need some value other than user id.
>
> There are many other connection-level properties available via calls
> to CONNECTION_PROPERTY().
>
> Breck.
>
> On 18 Feb 2008 09:33:45 -0800, "Victor Hernandez"
> <vhernandez@innova.com.mx> wrote:
>
>>Is there anyway to know the user names of who are connected to the
>>database?
>>
>>"Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__bcarter@risingroad.com>
>>wrote in message news:mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com...
>>> If by "sybase 9" you mean SQL Anywhere:
>>>
>>> SELECT COUNT(*) FROM sa_conn_info();
>>>
>>> Breck
>>>
>>> On 15 Feb 2008 13:49:37 -0800, "Victor Hernandez"
>>> <vhernandez@innova.com.mx> wrote:
>>>
>>>>
>>>>We are developing an application and we want to control concurrent users
>>>>accessing it. we're using PowerBuilder 9, SQLServer 2005/2000, sybase 9
>>>>and
>>>>oracle 8/9
>>>>
>>>>Is there any way I may know how many concurrent users are accessing my
>>>>application running on sybase, microsoft sql or oracle?
>>>>
>>>
>>> --
>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>
>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>> breck.carter@risingroad.com
>>
>
> --
> Breck Carter http://sqlanywhere.blogspot.com/
>
> RisingRoad SQL Anywhere and MobiLink Professional Services
> breck.carter@risingroad.com


Breck Carter [sqlanywhere.blogspot.com] Posted on 2008-02-19 20:35:03.0Z
From: "Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: sybase.public.commercial-isv.general
Subject: Re: Concurrent User control
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <32emr3hqfvcd9ciq3o0igpk2namrquv29p@4ax.com>
References: <47b608f1$1@forums-1-dub> <mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com> <47b9c179$1@forums-1-dub> <k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com> <47bafcd4$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 19 Feb 2008 12:35:03 -0800
X-Trace: forums-1-dub 1203453303 10.22.241.152 (19 Feb 2008 12:35:03 -0800)
X-Original-Trace: 19 Feb 2008 12:35:03 -0800, vip152.sybase.com
Lines: 88
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:64
Article PK: 103785

In SQL Anywhere, you get the connection number n, then build a "DROP
CONNECTION n" statement in a string and execute it via PowerBuilder's
EXECUTE IMMEDIATE. The connection *doing* the DROP must itself have
DBA authority.

For SQL Server have a look at the TRANSACT SQL statement KILL spid,
where spid is "system process id" of the connection.

For Oracle have a look at ALTER SYSTEM KILL SESSION or ALTER SYSTEM
DISCONNECT SESSION in the help.

Breck

On 19 Feb 2008 07:59:16 -0800, "Victor Hernandez"

<vhernandez@innova.com.mx> wrote:

>Is there a way a function in powerbuilder 9.0 (code or syntax) to disconnect
>users from the database remotely for (sybase 9.0 (sql anywhere),sqlserver
>and oracle 8.0/9.0)?
>
>"Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>
>wrote in message news:k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com...
>> Oh, yes, sa_conn_info() returns many interesting values...
>>
>> SELECT * FROM sa_conn_info();
>> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
>> 2,'ddd-1','DBA',0,'2008-02-18
>> 14:29:06.519',,,'CURSOR_FETCH','local','',800,,0,0,0
>> 1,'ddd-2','DBA',0,'2008-02-18
>> 14:28:51.799',,,'CURSOR_CLOSE','local','',0,,0,0,0
>>
>> The Userid column is probably what you want.
>>
>> The Name is the "CON" connection name connection string parameter that
>> is often empty but it's there for you to fill in in the connection
>> string if you need some value other than user id.
>>
>> There are many other connection-level properties available via calls
>> to CONNECTION_PROPERTY().
>>
>> Breck.
>>
>> On 18 Feb 2008 09:33:45 -0800, "Victor Hernandez"
>> <vhernandez@innova.com.mx> wrote:
>>
>>>Is there anyway to know the user names of who are connected to the
>>>database?
>>>
>>>"Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__bcarter@risingroad.com>
>>>wrote in message news:mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com...
>>>> If by "sybase 9" you mean SQL Anywhere:
>>>>
>>>> SELECT COUNT(*) FROM sa_conn_info();
>>>>
>>>> Breck
>>>>
>>>> On 15 Feb 2008 13:49:37 -0800, "Victor Hernandez"
>>>> <vhernandez@innova.com.mx> wrote:
>>>>
>>>>>
>>>>>We are developing an application and we want to control concurrent users
>>>>>accessing it. we're using PowerBuilder 9, SQLServer 2005/2000, sybase 9
>>>>>and
>>>>>oracle 8/9
>>>>>
>>>>>Is there any way I may know how many concurrent users are accessing my
>>>>>application running on sybase, microsoft sql or oracle?
>>>>>
>>>>
>>>> --
>>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>>
>>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>>> breck.carter@risingroad.com
>>>
>>
>> --
>> Breck Carter http://sqlanywhere.blogspot.com/
>>
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> breck.carter@risingroad.com
>

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com


Victor Hernandez Posted on 2008-02-19 21:11:18.0Z
From: "Victor Hernandez" <vhernandez@innova.com.mx>
Newsgroups: sybase.public.commercial-isv.general
References: <47b608f1$1@forums-1-dub> <mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com> <47b9c179$1@forums-1-dub> <k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com> <47bafcd4$1@forums-1-dub> <32emr3hqfvcd9ciq3o0igpk2namrquv29p@4ax.com>
Subject: Re: Concurrent User control
Lines: 98
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47bb45f6@forums-1-dub>
Date: 19 Feb 2008 13:11:18 -0800
X-Trace: forums-1-dub 1203455478 10.22.241.152 (19 Feb 2008 13:11:18 -0800)
X-Original-Trace: 19 Feb 2008 13:11:18 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:66
Article PK: 103790

Thanks im going to check it

"Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>

wrote in message news:32emr3hqfvcd9ciq3o0igpk2namrquv29p@4ax.com...
> In SQL Anywhere, you get the connection number n, then build a "DROP
> CONNECTION n" statement in a string and execute it via PowerBuilder's
> EXECUTE IMMEDIATE. The connection *doing* the DROP must itself have
> DBA authority.
>
> For SQL Server have a look at the TRANSACT SQL statement KILL spid,
> where spid is "system process id" of the connection.
>
> For Oracle have a look at ALTER SYSTEM KILL SESSION or ALTER SYSTEM
> DISCONNECT SESSION in the help.
>
> Breck
>
> On 19 Feb 2008 07:59:16 -0800, "Victor Hernandez"
> <vhernandez@innova.com.mx> wrote:
>
>>Is there a way a function in powerbuilder 9.0 (code or syntax) to
>>disconnect
>>users from the database remotely for (sybase 9.0 (sql anywhere),sqlserver
>>and oracle 8.0/9.0)?
>>
>>"Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>
>>wrote in message news:k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com...
>>> Oh, yes, sa_conn_info() returns many interesting values...
>>>
>>> SELECT * FROM sa_conn_info();
>>> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
>>> 2,'ddd-1','DBA',0,'2008-02-18
>>> 14:29:06.519',,,'CURSOR_FETCH','local','',800,,0,0,0
>>> 1,'ddd-2','DBA',0,'2008-02-18
>>> 14:28:51.799',,,'CURSOR_CLOSE','local','',0,,0,0,0
>>>
>>> The Userid column is probably what you want.
>>>
>>> The Name is the "CON" connection name connection string parameter that
>>> is often empty but it's there for you to fill in in the connection
>>> string if you need some value other than user id.
>>>
>>> There are many other connection-level properties available via calls
>>> to CONNECTION_PROPERTY().
>>>
>>> Breck.
>>>
>>> On 18 Feb 2008 09:33:45 -0800, "Victor Hernandez"
>>> <vhernandez@innova.com.mx> wrote:
>>>
>>>>Is there anyway to know the user names of who are connected to the
>>>>database?
>>>>
>>>>"Breck Carter [sqlanywhere.blogspot.com]"
>>>><NOSPAM__bcarter@risingroad.com>
>>>>wrote in message news:mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com...
>>>>> If by "sybase 9" you mean SQL Anywhere:
>>>>>
>>>>> SELECT COUNT(*) FROM sa_conn_info();
>>>>>
>>>>> Breck
>>>>>
>>>>> On 15 Feb 2008 13:49:37 -0800, "Victor Hernandez"
>>>>> <vhernandez@innova.com.mx> wrote:
>>>>>
>>>>>>
>>>>>>We are developing an application and we want to control concurrent
>>>>>>users
>>>>>>accessing it. we're using PowerBuilder 9, SQLServer 2005/2000, sybase
>>>>>>9
>>>>>>and
>>>>>>oracle 8/9
>>>>>>
>>>>>>Is there any way I may know how many concurrent users are accessing my
>>>>>>application running on sybase, microsoft sql or oracle?
>>>>>>
>>>>>
>>>>> --
>>>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>>>
>>>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>>>> breck.carter@risingroad.com
>>>>
>>>
>>> --
>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>
>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>> breck.carter@risingroad.com
>>
>
> --
> Breck Carter http://sqlanywhere.blogspot.com/
>
> RisingRoad SQL Anywhere and MobiLink Professional Services
> breck.carter@risingroad.com


Victor Hernandez Posted on 2008-02-20 16:05:36.0Z
From: "Victor Hernandez" <vhernandez@innova.com.mx>
Newsgroups: sybase.public.commercial-isv.general
References: <47b608f1$1@forums-1-dub> <mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com> <47b9c179$1@forums-1-dub> <k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com> <47bafcd4$1@forums-1-dub> <32emr3hqfvcd9ciq3o0igpk2namrquv29p@4ax.com> <47bb45f6@forums-1-dub>
Subject: Re: Concurrent User control
Lines: 106
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47bc4fd0$1@forums-1-dub>
Date: 20 Feb 2008 08:05:36 -0800
X-Trace: forums-1-dub 1203523536 10.22.241.152 (20 Feb 2008 08:05:36 -0800)
X-Original-Trace: 20 Feb 2008 08:05:36 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:68
Article PK: 103788

Does this also work with EAServer 5.2?

"Victor Hernandez" <vhernandez@innova.com.mx> wrote in message
news:47bb45f6@forums-1-dub...
> Thanks im going to check it
>
> "Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>
> wrote in message news:32emr3hqfvcd9ciq3o0igpk2namrquv29p@4ax.com...
>> In SQL Anywhere, you get the connection number n, then build a "DROP
>> CONNECTION n" statement in a string and execute it via PowerBuilder's
>> EXECUTE IMMEDIATE. The connection *doing* the DROP must itself have
>> DBA authority.
>>
>> For SQL Server have a look at the TRANSACT SQL statement KILL spid,
>> where spid is "system process id" of the connection.
>>
>> For Oracle have a look at ALTER SYSTEM KILL SESSION or ALTER SYSTEM
>> DISCONNECT SESSION in the help.
>>
>> Breck
>>
>> On 19 Feb 2008 07:59:16 -0800, "Victor Hernandez"
>> <vhernandez@innova.com.mx> wrote:
>>
>>>Is there a way a function in powerbuilder 9.0 (code or syntax) to
>>>disconnect
>>>users from the database remotely for (sybase 9.0 (sql anywhere),sqlserver
>>>and oracle 8.0/9.0)?
>>>
>>>"Breck Carter [sqlanywhere.blogspot.com]"
>>><NOSPAM__breck.carter@gmail.com>
>>>wrote in message news:k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com...
>>>> Oh, yes, sa_conn_info() returns many interesting values...
>>>>
>>>> SELECT * FROM sa_conn_info();
>>>> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
>>>> 2,'ddd-1','DBA',0,'2008-02-18
>>>> 14:29:06.519',,,'CURSOR_FETCH','local','',800,,0,0,0
>>>> 1,'ddd-2','DBA',0,'2008-02-18
>>>> 14:28:51.799',,,'CURSOR_CLOSE','local','',0,,0,0,0
>>>>
>>>> The Userid column is probably what you want.
>>>>
>>>> The Name is the "CON" connection name connection string parameter that
>>>> is often empty but it's there for you to fill in in the connection
>>>> string if you need some value other than user id.
>>>>
>>>> There are many other connection-level properties available via calls
>>>> to CONNECTION_PROPERTY().
>>>>
>>>> Breck.
>>>>
>>>> On 18 Feb 2008 09:33:45 -0800, "Victor Hernandez"
>>>> <vhernandez@innova.com.mx> wrote:
>>>>
>>>>>Is there anyway to know the user names of who are connected to the
>>>>>database?
>>>>>
>>>>>"Breck Carter [sqlanywhere.blogspot.com]"
>>>>><NOSPAM__bcarter@risingroad.com>
>>>>>wrote in message news:mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com...
>>>>>> If by "sybase 9" you mean SQL Anywhere:
>>>>>>
>>>>>> SELECT COUNT(*) FROM sa_conn_info();
>>>>>>
>>>>>> Breck
>>>>>>
>>>>>> On 15 Feb 2008 13:49:37 -0800, "Victor Hernandez"
>>>>>> <vhernandez@innova.com.mx> wrote:
>>>>>>
>>>>>>>
>>>>>>>We are developing an application and we want to control concurrent
>>>>>>>users
>>>>>>>accessing it. we're using PowerBuilder 9, SQLServer 2005/2000, sybase
>>>>>>>9
>>>>>>>and
>>>>>>>oracle 8/9
>>>>>>>
>>>>>>>Is there any way I may know how many concurrent users are accessing
>>>>>>>my
>>>>>>>application running on sybase, microsoft sql or oracle?
>>>>>>>
>>>>>>
>>>>>> --
>>>>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>>>>
>>>>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>>>>> breck.carter@risingroad.com
>>>>>
>>>>
>>>> --
>>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>>
>>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>>> breck.carter@risingroad.com
>>>
>>
>> --
>> Breck Carter http://sqlanywhere.blogspot.com/
>>
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> breck.carter@risingroad.com
>
>


Victor Hernandez Posted on 2008-02-25 16:47:57.0Z
From: "Victor Hernandez" <vhernandez@innova.com.mx>
Newsgroups: sybase.public.commercial-isv.general
References: <47b608f1$1@forums-1-dub> <mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com> <47b9c179$1@forums-1-dub> <k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com> <47bafcd4$1@forums-1-dub> <32emr3hqfvcd9ciq3o0igpk2namrquv29p@4ax.com>
Subject: Re: Concurrent User control
Lines: 98
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47c2f13d$1@forums-1-dub>
Date: 25 Feb 2008 08:47:57 -0800
X-Trace: forums-1-dub 1203958077 10.22.241.152 (25 Feb 2008 08:47:57 -0800)
X-Original-Trace: 25 Feb 2008 08:47:57 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:76
Article PK: 103798

Does this also work with EAServer 5.2?

"Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>

wrote in message news:32emr3hqfvcd9ciq3o0igpk2namrquv29p@4ax.com...
> In SQL Anywhere, you get the connection number n, then build a "DROP
> CONNECTION n" statement in a string and execute it via PowerBuilder's
> EXECUTE IMMEDIATE. The connection *doing* the DROP must itself have
> DBA authority.
>
> For SQL Server have a look at the TRANSACT SQL statement KILL spid,
> where spid is "system process id" of the connection.
>
> For Oracle have a look at ALTER SYSTEM KILL SESSION or ALTER SYSTEM
> DISCONNECT SESSION in the help.
>
> Breck
>
> On 19 Feb 2008 07:59:16 -0800, "Victor Hernandez"
> <vhernandez@innova.com.mx> wrote:
>
>>Is there a way a function in powerbuilder 9.0 (code or syntax) to
>>disconnect
>>users from the database remotely for (sybase 9.0 (sql anywhere),sqlserver
>>and oracle 8.0/9.0)?
>>
>>"Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>
>>wrote in message news:k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com...
>>> Oh, yes, sa_conn_info() returns many interesting values...
>>>
>>> SELECT * FROM sa_conn_info();
>>> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
>>> 2,'ddd-1','DBA',0,'2008-02-18
>>> 14:29:06.519',,,'CURSOR_FETCH','local','',800,,0,0,0
>>> 1,'ddd-2','DBA',0,'2008-02-18
>>> 14:28:51.799',,,'CURSOR_CLOSE','local','',0,,0,0,0
>>>
>>> The Userid column is probably what you want.
>>>
>>> The Name is the "CON" connection name connection string parameter that
>>> is often empty but it's there for you to fill in in the connection
>>> string if you need some value other than user id.
>>>
>>> There are many other connection-level properties available via calls
>>> to CONNECTION_PROPERTY().
>>>
>>> Breck.
>>>
>>> On 18 Feb 2008 09:33:45 -0800, "Victor Hernandez"
>>> <vhernandez@innova.com.mx> wrote:
>>>
>>>>Is there anyway to know the user names of who are connected to the
>>>>database?
>>>>
>>>>"Breck Carter [sqlanywhere.blogspot.com]"
>>>><NOSPAM__bcarter@risingroad.com>
>>>>wrote in message news:mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com...
>>>>> If by "sybase 9" you mean SQL Anywhere:
>>>>>
>>>>> SELECT COUNT(*) FROM sa_conn_info();
>>>>>
>>>>> Breck
>>>>>
>>>>> On 15 Feb 2008 13:49:37 -0800, "Victor Hernandez"
>>>>> <vhernandez@innova.com.mx> wrote:
>>>>>
>>>>>>
>>>>>>We are developing an application and we want to control concurrent
>>>>>>users
>>>>>>accessing it. we're using PowerBuilder 9, SQLServer 2005/2000, sybase
>>>>>>9
>>>>>>and
>>>>>>oracle 8/9
>>>>>>
>>>>>>Is there any way I may know how many concurrent users are accessing my
>>>>>>application running on sybase, microsoft sql or oracle?
>>>>>>
>>>>>
>>>>> --
>>>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>>>
>>>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>>>> breck.carter@risingroad.com
>>>>
>>>
>>> --
>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>
>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>> breck.carter@risingroad.com
>>
>
> --
> Breck Carter http://sqlanywhere.blogspot.com/
>
> RisingRoad SQL Anywhere and MobiLink Professional Services
> breck.carter@risingroad.com


Breck Carter [sqlanywhere.blogspot.com] Posted on 2008-02-25 20:40:27.0Z
From: "Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: sybase.public.commercial-isv.general
Subject: Re: Concurrent User control
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <4q96s3drej2u4ocef7la2ehopi4jlsfauv@4ax.com>
References: <47b608f1$1@forums-1-dub> <mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com> <47b9c179$1@forums-1-dub> <k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com> <47bafcd4$1@forums-1-dub> <32emr3hqfvcd9ciq3o0igpk2namrquv29p@4ax.com> <47c2f13d$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 25 Feb 2008 12:40:27 -0800
X-Trace: forums-1-dub 1203972027 10.22.241.152 (25 Feb 2008 12:40:27 -0800)
X-Original-Trace: 25 Feb 2008 12:40:27 -0800, vip152.sybase.com
Lines: 112
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:77
Article PK: 103800

I don't know... in a connection pool environment I'm guessing it might
not be a good idea to drop database connections from application code,
and I'm not sure you even can.

Breck

On 25 Feb 2008 08:47:57 -0800, "Victor Hernandez"

<vhernandez@innova.com.mx> wrote:

>Does this also work with EAServer 5.2?
>
>"Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>
>wrote in message news:32emr3hqfvcd9ciq3o0igpk2namrquv29p@4ax.com...
>> In SQL Anywhere, you get the connection number n, then build a "DROP
>> CONNECTION n" statement in a string and execute it via PowerBuilder's
>> EXECUTE IMMEDIATE. The connection *doing* the DROP must itself have
>> DBA authority.
>>
>> For SQL Server have a look at the TRANSACT SQL statement KILL spid,
>> where spid is "system process id" of the connection.
>>
>> For Oracle have a look at ALTER SYSTEM KILL SESSION or ALTER SYSTEM
>> DISCONNECT SESSION in the help.
>>
>> Breck
>>
>> On 19 Feb 2008 07:59:16 -0800, "Victor Hernandez"
>> <vhernandez@innova.com.mx> wrote:
>>
>>>Is there a way a function in powerbuilder 9.0 (code or syntax) to
>>>disconnect
>>>users from the database remotely for (sybase 9.0 (sql anywhere),sqlserver
>>>and oracle 8.0/9.0)?
>>>
>>>"Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>
>>>wrote in message news:k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com...
>>>> Oh, yes, sa_conn_info() returns many interesting values...
>>>>
>>>> SELECT * FROM sa_conn_info();
>>>> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
>>>> 2,'ddd-1','DBA',0,'2008-02-18
>>>> 14:29:06.519',,,'CURSOR_FETCH','local','',800,,0,0,0
>>>> 1,'ddd-2','DBA',0,'2008-02-18
>>>> 14:28:51.799',,,'CURSOR_CLOSE','local','',0,,0,0,0
>>>>
>>>> The Userid column is probably what you want.
>>>>
>>>> The Name is the "CON" connection name connection string parameter that
>>>> is often empty but it's there for you to fill in in the connection
>>>> string if you need some value other than user id.
>>>>
>>>> There are many other connection-level properties available via calls
>>>> to CONNECTION_PROPERTY().
>>>>
>>>> Breck.
>>>>
>>>> On 18 Feb 2008 09:33:45 -0800, "Victor Hernandez"
>>>> <vhernandez@innova.com.mx> wrote:
>>>>
>>>>>Is there anyway to know the user names of who are connected to the
>>>>>database?
>>>>>
>>>>>"Breck Carter [sqlanywhere.blogspot.com]"
>>>>><NOSPAM__bcarter@risingroad.com>
>>>>>wrote in message news:mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com...
>>>>>> If by "sybase 9" you mean SQL Anywhere:
>>>>>>
>>>>>> SELECT COUNT(*) FROM sa_conn_info();
>>>>>>
>>>>>> Breck
>>>>>>
>>>>>> On 15 Feb 2008 13:49:37 -0800, "Victor Hernandez"
>>>>>> <vhernandez@innova.com.mx> wrote:
>>>>>>
>>>>>>>
>>>>>>>We are developing an application and we want to control concurrent
>>>>>>>users
>>>>>>>accessing it. we're using PowerBuilder 9, SQLServer 2005/2000, sybase
>>>>>>>9
>>>>>>>and
>>>>>>>oracle 8/9
>>>>>>>
>>>>>>>Is there any way I may know how many concurrent users are accessing my
>>>>>>>application running on sybase, microsoft sql or oracle?
>>>>>>>
>>>>>>
>>>>>> --
>>>>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>>>>
>>>>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>>>>> breck.carter@risingroad.com
>>>>>
>>>>
>>>> --
>>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>>
>>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>>> breck.carter@risingroad.com
>>>
>>
>> --
>> Breck Carter http://sqlanywhere.blogspot.com/
>>
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> breck.carter@risingroad.com
>

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com


Jonathan Baker [Sybase] Posted on 2008-02-26 13:18:18.0Z
From: "Jonathan Baker [Sybase]" <lastnamefirstinitial@sybase.com>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
Newsgroups: sybase.public.commercial-isv.general
Subject: Re: Concurrent User control
References: <47b608f1$1@forums-1-dub> <mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com> <47b9c179$1@forums-1-dub> <k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com> <47bafcd4$1@forums-1-dub> <32emr3hqfvcd9ciq3o0igpk2namrquv29p@4ax.com> <47c2f13d$1@forums-1-dub> <4q96s3drej2u4ocef7la2ehopi4jlsfauv@4ax.com>
In-Reply-To: <4q96s3drej2u4ocef7la2ehopi4jlsfauv@4ax.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47c4119a$1@forums-1-dub>
Date: 26 Feb 2008 05:18:18 -0800
X-Trace: forums-1-dub 1204031898 10.22.241.152 (26 Feb 2008 05:18:18 -0800)
X-Original-Trace: 26 Feb 2008 05:18:18 -0800, vip152.sybase.com
Lines: 119
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:78
Article PK: 103799

You can, but it is definitely not recommended.

If you have too many open connections on an application server platform,
it may be that your cache isn't set up correctly. I've also noticed
this problem a lot with people who are holding connections in the code.
Both are worth checking if you start to see a problem.


Cheers,
Jonathan

Breck Carter [sqlanywhere.blogspot.com] wrote:
> I don't know... in a connection pool environment I'm guessing it might
> not be a good idea to drop database connections from application code,
> and I'm not sure you even can.
>
> Breck
>
> On 25 Feb 2008 08:47:57 -0800, "Victor Hernandez"
> <vhernandez@innova.com.mx> wrote:
>
>> Does this also work with EAServer 5.2?
>>
>> "Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>
>> wrote in message news:32emr3hqfvcd9ciq3o0igpk2namrquv29p@4ax.com...
>>> In SQL Anywhere, you get the connection number n, then build a "DROP
>>> CONNECTION n" statement in a string and execute it via PowerBuilder's
>>> EXECUTE IMMEDIATE. The connection *doing* the DROP must itself have
>>> DBA authority.
>>>
>>> For SQL Server have a look at the TRANSACT SQL statement KILL spid,
>>> where spid is "system process id" of the connection.
>>>
>>> For Oracle have a look at ALTER SYSTEM KILL SESSION or ALTER SYSTEM
>>> DISCONNECT SESSION in the help.
>>>
>>> Breck
>>>
>>> On 19 Feb 2008 07:59:16 -0800, "Victor Hernandez"
>>> <vhernandez@innova.com.mx> wrote:
>>>
>>>> Is there a way a function in powerbuilder 9.0 (code or syntax) to
>>>> disconnect
>>>> users from the database remotely for (sybase 9.0 (sql anywhere),sqlserver
>>>> and oracle 8.0/9.0)?
>>>>
>>>> "Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>
>>>> wrote in message news:k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com...
>>>>> Oh, yes, sa_conn_info() returns many interesting values...
>>>>>
>>>>> SELECT * FROM sa_conn_info();
>>>>> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
>>>>> 2,'ddd-1','DBA',0,'2008-02-18
>>>>> 14:29:06.519',,,'CURSOR_FETCH','local','',800,,0,0,0
>>>>> 1,'ddd-2','DBA',0,'2008-02-18
>>>>> 14:28:51.799',,,'CURSOR_CLOSE','local','',0,,0,0,0
>>>>>
>>>>> The Userid column is probably what you want.
>>>>>
>>>>> The Name is the "CON" connection name connection string parameter that
>>>>> is often empty but it's there for you to fill in in the connection
>>>>> string if you need some value other than user id.
>>>>>
>>>>> There are many other connection-level properties available via calls
>>>>> to CONNECTION_PROPERTY().
>>>>>
>>>>> Breck.
>>>>>
>>>>> On 18 Feb 2008 09:33:45 -0800, "Victor Hernandez"
>>>>> <vhernandez@innova.com.mx> wrote:
>>>>>
>>>>>> Is there anyway to know the user names of who are connected to the
>>>>>> database?
>>>>>>
>>>>>> "Breck Carter [sqlanywhere.blogspot.com]"
>>>>>> <NOSPAM__bcarter@risingroad.com>
>>>>>> wrote in message news:mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com...
>>>>>>> If by "sybase 9" you mean SQL Anywhere:
>>>>>>>
>>>>>>> SELECT COUNT(*) FROM sa_conn_info();
>>>>>>>
>>>>>>> Breck
>>>>>>>
>>>>>>> On 15 Feb 2008 13:49:37 -0800, "Victor Hernandez"
>>>>>>> <vhernandez@innova.com.mx> wrote:
>>>>>>>
>>>>>>>> We are developing an application and we want to control concurrent
>>>>>>>> users
>>>>>>>> accessing it. we're using PowerBuilder 9, SQLServer 2005/2000, sybase
>>>>>>>> 9
>>>>>>>> and
>>>>>>>> oracle 8/9
>>>>>>>>
>>>>>>>> Is there any way I may know how many concurrent users are accessing my
>>>>>>>> application running on sybase, microsoft sql or oracle?
>>>>>>>>
>>>>>>> --
>>>>>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>>>>>
>>>>>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>>>>>> breck.carter@risingroad.com
>>>>> --
>>>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>>>
>>>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>>>> breck.carter@risingroad.com
>>> --
>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>
>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>> breck.carter@risingroad.com
>
> --
> Breck Carter http://sqlanywhere.blogspot.com/
>
> RisingRoad SQL Anywhere and MobiLink Professional Services
> breck.carter@risingroad.com


M. Searer Posted on 2008-02-20 22:34:37.0Z
From: "M. Searer" <nospam@nospam.com>
Newsgroups: sybase.public.commercial-isv.general
References: <47b608f1$1@forums-1-dub> <mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com> <47b9c179$1@forums-1-dub> <k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com> <47bafcd4$1@forums-1-dub>
Subject: Re: Concurrent User control
Lines: 73
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47bcaafd$3@forums-1-dub>
Date: 20 Feb 2008 14:34:37 -0800
X-Trace: forums-1-dub 1203546877 10.22.241.152 (20 Feb 2008 14:34:37 -0800)
X-Original-Trace: 20 Feb 2008 14:34:37 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:70
Article PK: 103793

I just get the count at time of login and disconnect if they are over the
limit....

"Victor Hernandez" <vhernandez@innova.com.mx> wrote in message
news:47bafcd4$1@forums-1-dub...
> Is there a way a function in powerbuilder 9.0 (code or syntax) to disconnect
> users from the database remotely for (sybase 9.0 (sql anywhere),sqlserver and
> oracle 8.0/9.0)?
>
> "Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>
> wrote in message news:k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com...
>> Oh, yes, sa_conn_info() returns many interesting values...
>>
>> SELECT * FROM sa_conn_info();
>> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
>> 2,'ddd-1','DBA',0,'2008-02-18
>> 14:29:06.519',,,'CURSOR_FETCH','local','',800,,0,0,0
>> 1,'ddd-2','DBA',0,'2008-02-18
>> 14:28:51.799',,,'CURSOR_CLOSE','local','',0,,0,0,0
>>
>> The Userid column is probably what you want.
>>
>> The Name is the "CON" connection name connection string parameter that
>> is often empty but it's there for you to fill in in the connection
>> string if you need some value other than user id.
>>
>> There are many other connection-level properties available via calls
>> to CONNECTION_PROPERTY().
>>
>> Breck.
>>
>> On 18 Feb 2008 09:33:45 -0800, "Victor Hernandez"
>> <vhernandez@innova.com.mx> wrote:
>>
>>>Is there anyway to know the user names of who are connected to the database?
>>>
>>>"Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__bcarter@risingroad.com>
>>>wrote in message news:mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com...
>>>> If by "sybase 9" you mean SQL Anywhere:
>>>>
>>>> SELECT COUNT(*) FROM sa_conn_info();
>>>>
>>>> Breck
>>>>
>>>> On 15 Feb 2008 13:49:37 -0800, "Victor Hernandez"
>>>> <vhernandez@innova.com.mx> wrote:
>>>>
>>>>>
>>>>>We are developing an application and we want to control concurrent users
>>>>>accessing it. we're using PowerBuilder 9, SQLServer 2005/2000, sybase 9
>>>>>and
>>>>>oracle 8/9
>>>>>
>>>>>Is there any way I may know how many concurrent users are accessing my
>>>>>application running on sybase, microsoft sql or oracle?
>>>>>
>>>>
>>>> --
>>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>>
>>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>>> breck.carter@risingroad.com
>>>
>>
>> --
>> Breck Carter http://sqlanywhere.blogspot.com/
>>
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> breck.carter@risingroad.com
>
>


R. Pods Posted on 2008-02-20 13:50:03.0Z
From: "R. Pods" <r.pods@gmx.net>
User-Agent: Thunderbird 1.5.0.14 (Windows/20071210)
MIME-Version: 1.0
Newsgroups: sybase.public.commercial-isv.general
Subject: Re: Concurrent User control
References: <47b608f1$1@forums-1-dub> <mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com> <47b9c179$1@forums-1-dub> <k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com>
In-Reply-To: <k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47bc300b$1@forums-1-dub>
Date: 20 Feb 2008 05:50:03 -0800
X-Trace: forums-1-dub 1203515403 10.22.241.152 (20 Feb 2008 05:50:03 -0800)
X-Original-Trace: 20 Feb 2008 05:50:03 -0800, vip152.sybase.com
Lines: 30
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:67
Article PK: 103789

PMFJI, but I always wondered how to set that "CON" parameter from an
application, e.g. PowerBuilder or (yes, we still use it :-)) Power++.
Could you supply any example?

Reimer

Breck Carter [sqlanywhere.blogspot.com] schrieb:

> Oh, yes, sa_conn_info() returns many interesting values...
>
> SELECT * FROM sa_conn_info();
> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
> 2,'ddd-1','DBA',0,'2008-02-18
> 14:29:06.519',,,'CURSOR_FETCH','local','',800,,0,0,0
> 1,'ddd-2','DBA',0,'2008-02-18
> 14:28:51.799',,,'CURSOR_CLOSE','local','',0,,0,0,0
>
> The Userid column is probably what you want.
>
> The Name is the "CON" connection name connection string parameter that
> is often empty but it's there for you to fill in in the connection
> string if you need some value other than user id.
>
> There are many other connection-level properties available via calls
> to CONNECTION_PROPERTY().
>
> Breck.
>
> On 18 Feb 2008 09:33:45 -0800, "Victor Hernandez"
> <vhernandez@innova.com.mx> wrote:
>


"Paul Horan[Sybase]" <phoran_remove Posted on 2009-02-06 15:54:28.0Z
From: "Paul Horan[Sybase]" <phoran_remove@remove_sybase.com>
Newsgroups: sybase.public.commercial-isv.general
References: <47b608f1$1@forums-1-dub> <mtpdr3tqdh72g9f1ntick3uqqo9ikeks7a@4ax.com> <47b9c179$1@forums-1-dub> <k2njr3dglvus274f9req5bdo9uclegcteu@4ax.com> <47bc300b$1@forums-1-dub>
Subject: Re: Concurrent User control
Lines: 40
Organization: Sybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <498c5d34$1@forums-1-dub>
Date: 6 Feb 2009 07:54:28 -0800
X-Trace: forums-1-dub 1233935668 10.22.241.152 (6 Feb 2009 07:54:28 -0800)
X-Original-Trace: 6 Feb 2009 07:54:28 -0800, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:206
Article PK: 103923

It's the AppName parameter to the DBParm.

DBParm="ConnectString='blah',AppName='MyApplication'"

--
Paul Horan[Sybase]
paulhoran.pbdjmagazine.com

"R. Pods" <r.pods@gmx.net> wrote in message news:47bc300b$1@forums-1-dub...
> PMFJI, but I always wondered how to set that "CON" parameter from an
> application, e.g. PowerBuilder or (yes, we still use it :-)) Power++.
> Could you supply any example?
>
> Reimer
>
> Breck Carter [sqlanywhere.blogspot.com] schrieb:
>> Oh, yes, sa_conn_info() returns many interesting values...
>>
>> SELECT * FROM sa_conn_info();
>> Number,Name,Userid,DBNumber,LastReqTime,ProcessTime,Port,ReqType,CommLink,NodeAddr,LastIdle,CurrTaskSw,BlockedOn,LockName,UncmtOps
>> 2,'ddd-1','DBA',0,'2008-02-18
>> 14:29:06.519',,,'CURSOR_FETCH','local','',800,,0,0,0
>> 1,'ddd-2','DBA',0,'2008-02-18
>> 14:28:51.799',,,'CURSOR_CLOSE','local','',0,,0,0,0
>>
>> The Userid column is probably what you want. The Name is the "CON"
>> connection name connection string parameter that
>> is often empty but it's there for you to fill in in the connection
>> string if you need some value other than user id.
>>
>> There are many other connection-level properties available via calls
>> to CONNECTION_PROPERTY().
>>
>> Breck.
>>
>> On 18 Feb 2008 09:33:45 -0800, "Victor Hernandez"
>> <vhernandez@innova.com.mx> wrote:
>>


M. Searer Posted on 2008-02-17 16:52:45.0Z
From: "M. Searer" <nospam@nospam.com>
Newsgroups: sybase.public.commercial-isv.general
References: <47b608f1$1@forums-1-dub>
Subject: Re: Concurrent User control
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47b8665d$1@forums-1-dub>
Date: 17 Feb 2008 08:52:45 -0800
X-Trace: forums-1-dub 1203267165 10.22.241.152 (17 Feb 2008 08:52:45 -0800)
X-Original-Trace: 17 Feb 2008 08:52:45 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:59
Article PK: 103781

Note that Oracle is different in that instead of a program name, it has the .exe
name of your application.
ASE/MS SQL use the program name you identified in the database connection (you
decide what is in that value).

"Victor Hernandez" <vhernandez@innova.com.mx> wrote in message
news:47b608f1$1@forums-1-dub...
>
> We are developing an application and we want to control concurrent users
> accessing it. we're using PowerBuilder 9, SQLServer 2005/2000, sybase 9 and
> oracle 8/9
>
> Is there any way I may know how many concurrent users are accessing my
> application running on sybase, microsoft sql or oracle?
>


Jeff Gibson Posted on 2008-02-19 20:51:20.0Z
Reply-To: "Jeff Gibson" <jgibson@interceptsolutions.com>
From: "Jeff Gibson" <jgibson@interceptsolutions.com>
Newsgroups: sybase.public.commercial-isv.general
References: <47b608f1$1@forums-1-dub> <47b8665d$1@forums-1-dub>
Subject: Re: Concurrent User control
Lines: 31
Organization: Intercept Solutions
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47bb4148@forums-1-dub>
Date: 19 Feb 2008 12:51:20 -0800
X-Trace: forums-1-dub 1203454280 10.22.241.152 (19 Feb 2008 12:51:20 -0800)
X-Original-Trace: 19 Feb 2008 12:51:20 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:65
Article PK: 103787

How does that work Mike? In that Oracle has the name of the exe file.

It would be nice to be able to do that from SQL Anywhere.

Jeff Gibson
Intercept Solutions - Sybase SQL Anywhere OEM Partner
Nashville, TN

"M. Searer" <nospam@nospam.com> wrote in message
news:47b8665d$1@forums-1-dub...
> Note that Oracle is different in that instead of a program name, it has
> the .exe name of your application.
> ASE/MS SQL use the program name you identified in the database connection
> (you decide what is in that value).
>
>
>
> "Victor Hernandez" <vhernandez@innova.com.mx> wrote in message
> news:47b608f1$1@forums-1-dub...
>>
>> We are developing an application and we want to control concurrent users
>> accessing it. we're using PowerBuilder 9, SQLServer 2005/2000, sybase 9
>> and oracle 8/9
>>
>> Is there any way I may know how many concurrent users are accessing my
>> application running on sybase, microsoft sql or oracle?
>>
>
>


M. Searer Posted on 2008-02-20 22:34:37.0Z
From: "M. Searer" <nospam@nospam.com>
Newsgroups: sybase.public.commercial-isv.general
References: <47b608f1$1@forums-1-dub> <47b8665d$1@forums-1-dub> <47bb4148@forums-1-dub>
Subject: Re: Concurrent User control
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47bcaafd$1@forums-1-dub>
Date: 20 Feb 2008 14:34:37 -0800
X-Trace: forums-1-dub 1203546877 10.22.241.152 (20 Feb 2008 14:34:37 -0800)
X-Original-Trace: 20 Feb 2008 14:34:37 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:69
Article PK: 103794

Oracle puts it in automatically (the exe name).

sql anywhere, sql server, ase you have to send it up as part of the connect
string

"Jeff Gibson" <jgibson@interceptsolutions.com> wrote in message
news:47bb4148@forums-1-dub...
> How does that work Mike? In that Oracle has the name of the exe file.
>
> It would be nice to be able to do that from SQL Anywhere.
>
> Jeff Gibson
> Intercept Solutions - Sybase SQL Anywhere OEM Partner
> Nashville, TN
>
> "M. Searer" <nospam@nospam.com> wrote in message
> news:47b8665d$1@forums-1-dub...
>> Note that Oracle is different in that instead of a program name, it has the
>> .exe name of your application.
>> ASE/MS SQL use the program name you identified in the database connection
>> (you decide what is in that value).
>>
>>
>>
>> "Victor Hernandez" <vhernandez@innova.com.mx> wrote in message
>> news:47b608f1$1@forums-1-dub...
>>>
>>> We are developing an application and we want to control concurrent users
>>> accessing it. we're using PowerBuilder 9, SQLServer 2005/2000, sybase 9 and
>>> oracle 8/9
>>>
>>> Is there any way I may know how many concurrent users are accessing my
>>> application running on sybase, microsoft sql or oracle?
>>>
>>
>>
>
>


Breck Carter [sqlanywhere.blogspot.com] Posted on 2008-02-27 15:06:39.0Z
From: "Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: sybase.public.commercial-isv.general
Subject: Re: Concurrent User control
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <s3vas31f4rlv40fuqc82gcmtm7k253lgj3@4ax.com>
References: <47b608f1$1@forums-1-dub> <47b8665d$1@forums-1-dub> <47bb4148@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 27 Feb 2008 07:06:39 -0800
X-Trace: forums-1-dub 1204124799 10.22.241.152 (27 Feb 2008 07:06:39 -0800)
X-Original-Trace: 27 Feb 2008 07:06:39 -0800, vip152.sybase.com
Lines: 24
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:79
Article PK: 103803

Here is what AppInfo looks for SQL Anywhere 10.0.1...

SELECT CONNECTION_PROPERTY( 'AppInfo' );

CONNECTION_PROPERTY('AppInfo')
'IP=192.168.1.101;HOST=PAVILION2;OS=''Windows XP Build 2600 Service
Pack
2'';PID=0x1380;THREAD=0xe0;EXE=C:\\PROGRA~1\\SQLANY~1\\WIN32\\DBISQLG.EXE;VERSION=10.0.1.3579;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-300'

Breck

On 19 Feb 2008 12:51:20 -0800, "Jeff Gibson"

<jgibson@interceptsolutions.com> wrote:

>How does that work Mike? In that Oracle has the name of the exe file.
>
>It would be nice to be able to do that from SQL Anywhere.

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com


Jeff Gibson Posted on 2008-02-28 17:09:20.0Z
Reply-To: "Jeff Gibson" <jgibson@interceptsolutions.com>
From: "Jeff Gibson" <jgibson@interceptsolutions.com>
Newsgroups: sybase.public.commercial-isv.general
References: <47b608f1$1@forums-1-dub> <47b8665d$1@forums-1-dub> <47bb4148@forums-1-dub> <s3vas31f4rlv40fuqc82gcmtm7k253lgj3@4ax.com>
Subject: Re: Concurrent User control
Lines: 34
Organization: Intercept Solutions
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47c6eac0$1@forums-1-dub>
Date: 28 Feb 2008 09:09:20 -0800
X-Trace: forums-1-dub 1204218560 10.22.241.152 (28 Feb 2008 09:09:20 -0800)
X-Original-Trace: 28 Feb 2008 09:09:20 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:83
Article PK: 103805

Thanks for the heads up Breck.

Jeff Gibson
Intercept Solutions - Sybase SQL Anywhere OEM Partner
Nashville, TN

"Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>

wrote in message news:s3vas31f4rlv40fuqc82gcmtm7k253lgj3@4ax.com...
> Here is what AppInfo looks for SQL Anywhere 10.0.1...
>
> SELECT CONNECTION_PROPERTY( 'AppInfo' );
>
> CONNECTION_PROPERTY('AppInfo')
> 'IP=192.168.1.101;HOST=PAVILION2;OS=''Windows XP Build 2600 Service
> Pack
> 2'';PID=0x1380;THREAD=0xe0;EXE=C:\\PROGRA~1\\SQLANY~1\\WIN32\\DBISQLG.EXE;VERSION=10.0.1.3579;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-300'
>
> Breck
>
> On 19 Feb 2008 12:51:20 -0800, "Jeff Gibson"
> <jgibson@interceptsolutions.com> wrote:
>
>>How does that work Mike? In that Oracle has the name of the exe file.
>>
>>It would be nice to be able to do that from SQL Anywhere.
>
>
> --
> Breck Carter http://sqlanywhere.blogspot.com/
>
> RisingRoad SQL Anywhere and MobiLink Professional Services
> breck.carter@risingroad.com


Yoyo Young Posted on 2008-02-18 04:29:36.0Z
Reply-To: "Yoyo Young" <young@public1.wx.js.cn>
From: "Yoyo Young" <young@public1.wx.js.cn>
Newsgroups: sybase.public.commercial-isv.general
References: <47b608f1$1@forums-1-dub>
Subject: Re: Concurrent User control
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.3959
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4073
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47b909b0$1@forums-1-dub>
Date: 17 Feb 2008 20:29:36 -0800
X-Trace: forums-1-dub 1203308976 10.22.241.152 (17 Feb 2008 20:29:36 -0800)
X-Original-Trace: 17 Feb 2008 20:29:36 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.commercial-isv.general:60
Article PK: 103782

If you use connection pool(EAServer), you'd better log the login transaction
for control.

Yoyo

"Victor Hernandez" <vhernandez@innova.com.mx> wrote in message
news:47b608f1$1@forums-1-dub...
>
> We are developing an application and we want to control concurrent users
> accessing it. we're using PowerBuilder 9, SQLServer 2005/2000, sybase 9
> and oracle 8/9
>
> Is there any way I may know how many concurrent users are accessing my
> application running on sybase, microsoft sql or oracle?
>