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.

iAnywhere manual disconnect (ADS 8.0)

3 posts in General Discussion Last posting was on 2008-07-22 09:44:31.0Z
Eric Bauer Posted on 2008-07-21 12:45:31.0Z
From: "Eric Bauer" <None@available.com>
Newsgroups: ianywhere.public.general
Subject: iAnywhere manual disconnect (ADS 8.0)
Lines: 12
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: <488484eb@forums-1-dub>
Date: 21 Jul 2008 05:45:31 -0700
X-Trace: forums-1-dub 1216644331 10.22.241.152 (21 Jul 2008 05:45:31 -0700)
X-Original-Trace: 21 Jul 2008 05:45:31 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6980
Article PK: 5205

Hello,

We've run into a situation where an application connecting to an iAnywhere
(ADS 8.0) server will not disconnect after completing its queries. Is there
a way to invoke Arc32.exe from a command line to disconnect a client with a
particular name/ip rather than manually doing so through the Architect GUI?

Thank you,

Eric


"Frank Ploessel" <fpl... Posted on 2008-07-21 17:22:02.0Z
Subject: Re: iAnywhere manual disconnect (ADS 8.0)
From: "Frank Ploessel" <fpl...@d_e.i_m_s_h_e_a_l_t_h.c_o_m>
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
References: <488484eb@forums-1-dub>
Content-Transfer-Encoding: Quoted-Printable
Message-ID: <op.uenjuwnlj0bybf@bonw00164.internal.imsglobal.com>
User-Agent: Opera Mail/9.21 (Win32)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 21 Jul 2008 10:22:02 -0700
X-Trace: forums-1-dub 1216660922 10.22.241.152 (21 Jul 2008 10:22:02 -0700)
X-Original-Trace: 21 Jul 2008 10:22:02 -0700, vip152.sybase.com
Lines: 74
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6981
Article PK: 5206

Eric,

Assuming that arc32.exe and Archtect GUI are a specific application, the
first contact for this question should be the vendor.

However, if you are sure you know what you are doing, I can give you some
hints on how you can find a way to do this:
Generate a file disconnect.sql with contents similar to the following few
lines:

begin
declare @conn_number integer;

select i.number
into @conn_number
from sa_conn_list(null,-1) c
join sa_conn_info() i on c.number = i.number
where i.nodeaddr = '172.186.0.1' and i.userid='frank'
;
execute immediate 'drop connection ' || @conn_number;
end;

Then call dbisql with a command lien simlar to the following:

dbisql -nogui -c "uid=uuu;pwd=ppp;dsn=abc" read disconnect.sql

You should obviously replace the IP address and user name in the script
file with the values appropriate for your situation. And in the call to
dbisql, replace uuu with a valid database user name with dba rights, ppp
with this user's password, and dsn with the ODBC source defining the
database access.

Frank

On Mon, 21 Jul 2008 14:45:31 +0200, Eric Bauer <None@available.com> wrote:

> Hello,
>
> We've run into a situation where an application connecting to an
> iAnywhere
> (ADS 8.0) server will not disconnect after completing its queries. Is
> there
> a way to invoke Arc32.exe from a command line to disconnect a client
> with a
> particular name/ip rather than manually doing so through the Architect
> GUI?
>
> Thank you,
>
> Eric
>
>


Breck Carter [sqlanywhere.blogspot.com] Posted on 2008-07-22 09:44:31.0Z
From: "Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: iAnywhere manual disconnect (ADS 8.0)
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <elab8457shj9fosm60gibe7gtm6q14avr3@4ax.com>
References: <488484eb@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: 22 Jul 2008 02:44:31 -0700
X-Trace: forums-1-dub 1216719871 10.22.241.152 (22 Jul 2008 02:44:31 -0700)
X-Original-Trace: 22 Jul 2008 02:44:31 -0700, vip152.sybase.com
Lines: 27
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6982
Article PK: 5207

I don't know if there are any ADS experts lurking on this forum, in
spite of its "general" name. Check this website out:
http://devzone.advantagedatabase.com/dz/content.aspx?key=1

Breck


On 21 Jul 2008 05:45:31 -0700, "Eric Bauer" <None@available.com>

wrote:

>Hello,
>
>We've run into a situation where an application connecting to an iAnywhere
>(ADS 8.0) server will not disconnect after completing its queries. Is there
>a way to invoke Arc32.exe from a command line to disconnect a client with a
>particular name/ip rather than manually doing so through the Architect GUI?
>
>Thank you,
>
>Eric
>

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

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