Friday, March 30, 2012

MSDE and ADO

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
Connection pooling is the probably cause. See this article:
http://msdn.microsoft.com/library/de...l/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
"Marcos Lommez" <lommez@.hotmail.com> wrote in message
news:O18zpcbUGHA.5108@.TK2MSFTNGP09.phx.gbl...
> 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
>
>
|||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...
> Connection pooling is the probably cause. See this article:
>
http://msdn.microsoft.com/library/de...l/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
> "Marcos Lommez" <lommez@.hotmail.com> wrote in message
> news:O18zpcbUGHA.5108@.TK2MSFTNGP09.phx.gbl...
>
sql

No comments:

Post a Comment