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.

Finding who is accessing server

3 posts in General Discussion Last posting was on 2007-10-26 14:04:06.0Z
Herman Miller Posted on 2007-10-25 19:25:16.0Z
Sender: 6f6d.472092da.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: Finding who is accessing server
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4720ed9c.7d26.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 25 Oct 2007 12:25:16 -0700
X-Trace: forums-1-dub 1193340316 10.22.241.41 (25 Oct 2007 12:25:16 -0700)
X-Original-Trace: 25 Oct 2007 12:25:16 -0700, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6486
Article PK: 2917

Is there anyway to create a log on a server to tell what
users, computers are accessing the database server? I would
like to document this as to not break something when I
upgrade from ASA9 to ASA10. Are ASA9 user able to access an
ASA10 database if their program files are not updated to
asa10?


David Fishburn Posted on 2007-10-25 20:54:01.0Z
Newsgroups: ianywhere.public.general
Subject: Re: Finding who is accessing server
From: David Fishburn <fishburn_spam@off.ianywhere.com>
References: <4720ed9c.7d26.1681692777@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns99D4ABC22327Bfishburnsybasecom@127.0.0.1>
User-Agent: Xnews/2005.10.18 Hamster/2.1.0.0
NNTP-Posting-Host: fishburn-m20.sybase.com
X-Original-NNTP-Posting-Host: fishburn-m20.sybase.com
Date: 25 Oct 2007 13:54:01 -0700
X-Trace: forums-1-dub 1193345641 10.25.98.137 (25 Oct 2007 13:54:01 -0700)
X-Original-Trace: 25 Oct 2007 13:54:01 -0700, fishburn-m20.sybase.com
Lines: 53
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6488
Article PK: 2918

Herman Miller wrote in news:4720ed9c.7d26.1681692777@sybase.com
of ianywhere.public.general:

HM> Is there anyway to create a log on a server to tell what
HM> users, computers are accessing the database server? I would
HM> like to document this as to not break something when I
HM> upgrade from ASA9 to ASA10. Are ASA9 user able to access an
HM> ASA10 database if their program files are not updated to
HM> asa10?

Not sure what you mean.

You can run sa_conn_info() which will return some information for you.
The APPINFO contains information about the IP addresses of the users
connected.

I am not sure what you want to log or how often?

That should give you a good head start.

ASA SQL Reference
System Procedures and Functions
System and catalog stored procedures
sa_conn_info system procedure


ASA Database Administration Guide
Database Performance and Connection Properties
Database properties
Connection-level properties
appinfo

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng10 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList


Rob Waywell Posted on 2007-10-26 14:04:06.0Z
From: "Rob Waywell" <rwaywell_no_spam_please@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <4720ed9c.7d26.1681692777@sybase.com>
Subject: Re: Finding who is accessing server
Lines: 38
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: rwaywell-xp2.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-xp2.sybase.com
Message-ID: <4721f3d6$1@forums-1-dub>
Date: 26 Oct 2007 07:04:06 -0700
X-Trace: forums-1-dub 1193407446 10.25.98.235 (26 Oct 2007 07:04:06 -0700)
X-Original-Trace: 26 Oct 2007 07:04:06 -0700, rwaywell-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6491
Article PK: 2919

Yes ASA 9 clients can connect to a SQL Anywhere 10 server. This section of
the documentation is a good starting point when researching and planning
your upgrade:

SQL Anywhere® 10 - Changes and Upgrading

Upgrading to SQL Anywhere 10

Upgrading SQL Anywhere

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

<Herman Miller> wrote in message news:4720ed9c.7d26.1681692777@sybase.com...
> Is there anyway to create a log on a server to tell what
> users, computers are accessing the database server? I would
> like to document this as to not break something when I
> upgrade from ASA9 to ASA10. Are ASA9 user able to access an
> ASA10 database if their program files are not updated to
> asa10?