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.

Database make connection and drop connection

2 posts in General Discussion Last posting was on 2004-01-30 17:07:00.0Z
Chandresh Patel Posted on 2004-01-30 16:21:09.0Z
Sender: 72d9.401a8585.1804289383@sybase.com
From: Chandresh Patel
Newsgroups: ianywhere.public.general
Subject: Database make connection and drop connection
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <401a86db.72ed.846930886@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 30 Jan 2004 08:31:23 -0800, 10.22.241.42
Lines: 21
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 30 Jan 2004 08:04:23 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 30 Jan 2004 08:21:09 -0800
X-Trace: forums-1-dub 1075479669 10.22.108.75 (30 Jan 2004 08:21:09 -0800)
X-Original-Trace: 30 Jan 2004 08:21:09 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2411
Article PK: 5550

Hi,

I developed one C# application and I have 10 user copy
sybase anywhere 9.0.

After, connect my application I open sybase central and look
for current user and it shows two because one for
application and one for sybase central. Now after login in
to my application I close the connection using mCnn.Close();
command and then go to the sybase central and refresh that
area but still it shows two connection.

My altimate goal is 25 user going to use this application
and I have 10 user copy so i want to do this like connect
application and drop connection, do query and drop
connection.

tell me this is the correct way to do OR how can I drop
connection after passing query and any database transation.

Thanks in advance.


"Jason Hinsperger" <jason_hinsperger Posted on 2004-01-30 17:07:00.0Z
From: "Jason Hinsperger" <jason_hinsperger@NO_SP_AM_hotmail.com>
Newsgroups: ianywhere.public.general
References: <401a86db.72ed.846930886@sybase.com>
Subject: Re: Database make connection and drop connection
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: 209.47.255.217
Message-ID: <401a919a$1@forums-2-dub>
X-Original-Trace: 30 Jan 2004 09:17:14 -0800, 209.47.255.217
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 30 Jan 2004 08:50:15 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 30 Jan 2004 09:07:00 -0800
X-Trace: forums-1-dub 1075482420 10.22.108.75 (30 Jan 2004 09:07:00 -0800)
X-Original-Trace: 30 Jan 2004 09:07:00 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2412
Article PK: 5553

You'll want to trun off connection pooling (it is on by default). Add the
string 'pooling=false' to your connect string.


--
Jason Hinsperger
International and Sustaining Engineering
iAnywhere Solutions

<Chandresh Patel> wrote in message
news:401a86db.72ed.846930886@sybase.com...
> Hi,
>
> I developed one C# application and I have 10 user copy
> sybase anywhere 9.0.
>
> After, connect my application I open sybase central and look
> for current user and it shows two because one for
> application and one for sybase central. Now after login in
> to my application I close the connection using mCnn.Close();
> command and then go to the sybase central and refresh that
> area but still it shows two connection.
>
> My altimate goal is 25 user going to use this application
> and I have 10 user copy so i want to do this like connect
> application and drop connection, do query and drop
> connection.
>
> tell me this is the correct way to do OR how can I drop
> connection after passing query and any database transation.
>
> Thanks in advance.