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.

Which applications are connected to my database

4 posts in General Discussion Last posting was on 2008-06-02 14:35:52.0Z
Jo segers Posted on 2008-06-02 13:32:28.0Z
Sender: 66c2.4843f3dd.1804289383@sybase.com
From: Jo segers
Newsgroups: ianywhere.public.general
Subject: Which applications are connected to my database
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4843f66c.6717.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Jun 2008 06:32:28 -0700
X-Trace: forums-1-dub 1212413548 10.22.241.41 (2 Jun 2008 06:32:28 -0700)
X-Original-Trace: 2 Jun 2008 06:32:28 -0700, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6868
Article PK: 5102

How can I find out which applications are connected to my
database. I can see the Ip-addresses of the connections but
not the application name.

Sybase SQL Anywhere 9.0.2

Best regards,

Jo Segers


Chris Keating (Sybase iAnywhere) Posted on 2008-06-02 13:56:41.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_spam_free@ianywhere.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Which applications are connected to my database
References: <4843f66c.6717.1681692777@sybase.com>
In-Reply-To: <4843f66c.6717.1681692777@sybase.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: <4843fc19$1@forums-1-dub>
Date: 2 Jun 2008 06:56:41 -0700
X-Trace: forums-1-dub 1212415001 10.22.241.152 (2 Jun 2008 06:56:41 -0700)
X-Original-Trace: 2 Jun 2008 06:56:41 -0700, vip152.sybase.com
Lines: 34
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6869
Article PK: 5103

The connection property AppInfo includes the EXE details of the client
application. The following query will return the AppInfo property for
each connection:


select CONNECTION_PROPERTY( 'AppInfo',ci.Number) from sa_conn_info() ci

--

Chris Keating

****************************************
Please only post to the newsgroup

SQL Anywhere Developer Community
http://www.sybase.com/developer/library/sql-anywhere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs
Maintenance releases and EBFs
http://downloads.sybase.com/swx/sdmain.stm
Use Case Express to report bugs
http://case-express.sybase.com

Jo segers wrote:
> How can I find out which applications are connected to my
> database. I can see the Ip-addresses of the connections but
> not the application name.
>
> Sybase SQL Anywhere 9.0.2
>
> Best regards,
>
> Jo Segers


Graeme Perrow Posted on 2008-06-02 14:11:14.0Z
From: Graeme Perrow <ReplyToNewsgroupOnly-gperrowNO@SPAMianywhere.PLEASEcom>
Reply-To: ReplyToNewsgroupOnly-gperrowNO@SPAMianywhere.PLEASEcom
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Which applications are connected to my database
References: <4843f66c.6717.1681692777@sybase.com> <4843fc19$1@forums-1-dub>
In-Reply-To: <4843fc19$1@forums-1-dub>
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: <4843ff82$1@forums-1-dub>
Date: 2 Jun 2008 07:11:14 -0700
X-Trace: forums-1-dub 1212415874 10.22.241.152 (2 Jun 2008 07:11:14 -0700)
X-Original-Trace: 2 Jun 2008 07:11:14 -0700, vip152.sybase.com
Lines: 50
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6870
Article PK: 5104

Note that if the client application is running on Unix, the EXE field is
not available. In SA version 11.0, the EXE field will be available for
clients running on Linux and Solaris.

Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere

SQL Anywhere Developer Community
http://www.sybase.com/developer/library/sql-anywhere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs

Chris Keating (Sybase iAnywhere) wrote:
> The connection property AppInfo includes the EXE details of the client
> application. The following query will return the AppInfo property for
> each connection:
>
>
> select CONNECTION_PROPERTY( 'AppInfo',ci.Number) from sa_conn_info() ci
>
> --
>
> Chris Keating
>
> ****************************************
> Please only post to the newsgroup
>
> SQL Anywhere Developer Community
> http://www.sybase.com/developer/library/sql-anywhere-techcorner
> SQL Anywhere Blog Center
> http://www.sybase.com/sqlanyblogs
> Maintenance releases and EBFs
> http://downloads.sybase.com/swx/sdmain.stm
> Use Case Express to report bugs
> http://case-express.sybase.com
>
>
> Jo segers wrote:
>> How can I find out which applications are connected to my
>> database. I can see the Ip-addresses of the connections but
>> not the application name.
>>
>> Sybase SQL Anywhere 9.0.2
>>
>> Best regards,
>>
>> Jo Segers


Jo segers Posted on 2008-06-02 14:35:52.0Z
Sender: 66c2.4843f3dd.1804289383@sybase.com
From: Jo Segers
Newsgroups: ianywhere.public.general
Subject: Re: Which applications are connected to my database
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48440548.691f.1681692777@sybase.com>
References: <4843ff82$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Jun 2008 07:35:52 -0700
X-Trace: forums-1-dub 1212417352 10.22.241.41 (2 Jun 2008 07:35:52 -0700)
X-Original-Trace: 2 Jun 2008 07:35:52 -0700, 10.22.241.41
Lines: 60
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6871
Article PK: 5105

Thanks for the info.

Best regards,

Jo.

> Note that if the client application is running on Unix,
> the EXE field is not available. In SA version 11.0, the
> EXE field will be available for clients running on Linux
> and Solaris.
>
> Graeme Perrow
> Senior Software Developer
> gperrow _at_ ianywhere _dot_ com
> Sybase iAnywhere
>
> SQL Anywhere Developer Community
>
>
http://www.sybase.com/developer/library/sql-anywhere-techcorner
> SQL Anywhere Blog Center
> http://www.sybase.com/sqlanyblogs
>
>
> Chris Keating (Sybase iAnywhere) wrote:
> > The connection property AppInfo includes the EXE details
> > of the client application. The following query will
> > return the AppInfo property for each connection:
> >
> >
> > select CONNECTION_PROPERTY( 'AppInfo',ci.Number) from
> > sa_conn_info() ci
> > --
> >
> > Chris Keating
> >
> > ****************************************
> > Please only post to the newsgroup
> >
> > SQL Anywhere Developer Community
> >
>
http://www.sybase.com/developer/library/sql-anywhere-techcorner
> > SQL Anywhere Blog Center
> > http://www.sybase.com/sqlanyblogs
> > Maintenance releases and EBFs
> > http://downloads.sybase.com/swx/sdmain.stm
> > Use Case Express to report bugs
> > http://case-express.sybase.com
> >
> >
> > Jo segers wrote:
> >> How can I find out which applications are connected to
> my >> database. I can see the Ip-addresses of the
> connections but >> not the application name.
> >>
> >> Sybase SQL Anywhere 9.0.2
> >>
> >> Best regards,
> >>
> >> Jo Segers