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.

How is the dbclient -c switch handled under Version 9?

2 posts in General Discussion Last posting was on 2004-07-22 16:30:21.0Z
Lorraine Ford Posted on 2004-07-22 15:23:59.0Z
Reply-To: "Lorraine Ford" <lford@ttisoftware.com>
From: "Lorraine Ford" <lford@ttisoftware.com>
Newsgroups: ianywhere.public.general
Subject: How is the dbclient -c switch handled under Version 9?
Lines: 33
Organization: Transportation Technologies Inc.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4922.1500
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4939.300
X-Original-NNTP-Posting-Host: h-69-3-43-2.phlapafg.covad.net
Message-ID: <40ffdd02$1@forums-2-dub>
X-Original-Trace: 22 Jul 2004 08:28:02 -0700, h-69-3-43-2.phlapafg.covad.net
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 22 Jul 2004 08:17:13 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 22 Jul 2004 08:23:59 -0700
X-Trace: forums-1-dub 1090509839 10.22.108.75 (22 Jul 2004 08:23:59 -0700)
X-Original-Trace: 22 Jul 2004 08:23:59 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3294
Article PK: 7207

I am in the final acceptance testing phase of converting our embedded SQL
anywhere application database from version 5.5 to version 9. It is going
great!

My question is, we found it necessary under version 5 to connect to the
database serveras a network client with the -c switch on the dbclient start
line in our
ODBC connection parameters.
This is not the -c that means the cache size as on the dbeng5, it has to do
with clearing the connection at the server, when the client application
terminates abnormally
(ie. our customer does a ctrl-alt-del on the client of our application).

If we did NOT have the dbclient started with the -c switch on version 5, the
database connection would be left on the server side when the application
terminated abnormally.
With the -c switch present, it cleared the connection on the server, which
is the behavior we need under version 9.

I have read much of the documentation and newsgroups and can't find anything
pertaining tothis. Is the connection automatically cleared under version 9
so we no
longer have to do anything or is here some other parameter we need in the
ODBC
network connection settings (note we are using TCPIP).

Any help would be appreciated!
Lorraine Ford
Transportation Technologies Inc.


Graeme Perrow Posted on 2004-07-22 16:30:21.0Z
From: Graeme Perrow <gperrowNO@SPAMianywhere.PLEASEcom>
Reply-To: gperrowNO@SPAMianywhere.PLEASEcom
Organization: iAnywhere Solutions, Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: How is the dbclient -c switch handled under Version 9?
References: <40ffdd02$1@forums-2-dub>
In-Reply-To: <40ffdd02$1@forums-2-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gperrow-pc.sybase.com
X-Original-NNTP-Posting-Host: gperrow-pc.sybase.com
Message-ID: <40ffeb9d$1@forums-1-dub>
Date: 22 Jul 2004 09:30:21 -0700
X-Trace: forums-1-dub 1090513821 10.25.107.224 (22 Jul 2004 09:30:21 -0700)
X-Original-Trace: 22 Jul 2004 09:30:21 -0700, gperrow-pc.sybase.com
Lines: 59
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3295
Article PK: 7208

In versions 6.0 and up, this is not necessary, for two reasons:

1. In 5.x, the application makes a connection to dbclient, and dbclient
makes a connection to the server. In 6.x and up, there *is* no dbclient,
and the application makes a connection directly to the server.

2. In 5.x, "tcpip" connections actually used UDP, a connectionless
protocol. This means that when the client went away, dbclient would have
no way of knowing this, and so couldn't tell the server to drop the
connection. In 6.x and up, tcpip connections use TCP/IP, so when the
application goes away, the server is instantly notified and can close
the database connection.

Graeme Perrow
Senior Software Developer
gperrow@ianywhere.com
iAnywhere Solutions Inc.
A Sybase company

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer/

Lorraine Ford wrote:
> I am in the final acceptance testing phase of converting our embedded SQL
> anywhere application database from version 5.5 to version 9. It is going
> great!
>
> My question is, we found it necessary under version 5 to connect to the
> database serveras a network client with the -c switch on the dbclient start
> line in our
> ODBC connection parameters.
> This is not the -c that means the cache size as on the dbeng5, it has to do
> with clearing the connection at the server, when the client application
> terminates abnormally
> (ie. our customer does a ctrl-alt-del on the client of our application).
>
> If we did NOT have the dbclient started with the -c switch on version 5, the
> database connection would be left on the server side when the application
> terminated abnormally.
> With the -c switch present, it cleared the connection on the server, which
> is the behavior we need under version 9.
>
> I have read much of the documentation and newsgroups and can't find anything
> pertaining tothis. Is the connection automatically cleared under version 9
> so we no
> longer have to do anything or is here some other parameter we need in the
> ODBC
> network connection settings (note we are using TCPIP).
>
> Any help would be appreciated!
> Lorraine Ford
> Transportation Technologies Inc.
>
>
>
>