sql server msde: Connection pooling is the probably cause. See this article:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/pooling2.asp


--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]

When i call ADOConnection.Connected := False
The connection with the MSDE server is still opened, why that?
I want to close that connection with the server

The connection is only closed when my application is terminated

Im using MSDE 2000 and my application is writen in Delphi

hi Marcos,
[quoted text, click to view]

ADO uses connection pooling, that's to say the connections you close and set
to nothing are released from you point of view, but the underlying object
still keep them form destroyng them in order to allow a speedly
"resurrection" if required to.. orphaned connections will be destroyed about
1 minute after they are released or when the application exits..
if you really need to disable connection pooling (remember that creating a
connection is an expensive task), you can specify the
OLE DB Services=-2;
parameter in your connection string...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Thanks
I have found the solution in that article

I just need to put the ';OLE DB Services = -2' to the end of my connetion
string


"Roger Wolter[MSFT]" <rwolter@online.microsoft.com> escreveu na mensagem
news:%23Bd2jedUGHA.736@TK2MSFTNGP12.phx.gbl...
[quoted text, click to view]