Re: TADOConnection does not close connection on SQL Server until destroyed?

Article View: borland.public.cppbuilder.database.ado

Article #5545

Back to borland.public.cppbuilder.database.ado Previous Next

#5545

From: Mehrdad Momeni
Date: Mon, 09 Apr 2001 17:07

34 lines
1777 bytes

Hi Piero

ADO has a caching mechanism on its connections. By default this cache works
(and gives performance benifits). If you insist, you can turn off the cache
by including somthing like "OLE DB SERVICES = 0" in the connection string of
your TADOConnection.

erAdat
Mehrdad

"Piero Salandin" <piero.salandin@libero.it> wrote in message
news:3ad1a320_1@dnews...
> C++Builder 5 Enterprise on W98
>
> I tried the behaviour of a TADOConnection with MS Sql Server, and using
the
> SQL Server Profiler I saw that the connection does not really closes when
I
> issue a TADOConn->Close() but only when I end the application (and the
> DataModule is removed from memory).
>
> Anyone can explain me why?
>
> Thanks a lot
>
>
> --
> Ing. Piero Salandin
> piero.salandin@libero.it
>
>
>
>
>

Technical Details

Message-ID: <3ad1ea2e_2@dnews>

Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!sn-xit-04!supernews.com!feed.textport.net!news.bnb-lp.com!dnews

References: <3ad1a320_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,563a3435b98cde2d
X-Google-Attributes: gid10698b,public
X-Google-Thread: f5cad,563a3435b98cde2d
X-Google-Attributes: gidf5cad,public
X-Google-ArrivalTime: 2001-04-09 10:12:26 PST
From: "Mehrdad Momeni" <nosa@mavara.com>
Newsgroups: borland.public.cppbuilder.database.ado,borland.public.delphi.database.ado
References: <3ad1a320_1@dnews>
Subject: Re: TADOConnection does not close connection on SQL Server until destroyed?
Date: Mon, 9 Apr 2001 21:37:59 +0430
Lines: 36
Organization: Nosa Co
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 195.96.156.203
Message-ID: <3ad1ea2e_2@dnews>
X-Trace: dnews 986835502 195.96.156.203 (9 Apr 2001 09:58:22 -0700)
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!sn-xit-04!supernews.com!feed.textport.net!news.bnb-lp.com!dnews

Reply to Parent Message