Página 1 de 1

ADO/ADS question

Publicado: Lun Dic 17, 2007 5:03 pm
por Pedro Sousa e Faro
Hi
I noticed that if we access via "ADO " to ADS , the connection is created
ok, but i can't kill the connection (even when we exit the aplication)
I tried:
::oAdo:lConnected:=.f.
::oAdo:End()
But the connections still on ADS.
The same happens with the Tables. SQL queries opens the tables but never
close it.
After some time without access , ADS kils the connection and close the
Tables.
Best regards
pedro

ADO/ADS question

Publicado: Lun Dic 17, 2007 5:11 pm
por ignacio
Pedro,
As ADO implements a common interface for any Database server, I believe the
problem is in ADS ADO client, on contrary, we should have that same problem
with any other database server.
Regards,
--
Ignacio Ortiz de Zúñiga
http://www.xailer.com
"Pedro Faro" <psfaro@shi.pt> escribió en el mensaje
news:47669e00$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> Hi
>
> I noticed that if we access via "ADO " to ADS , the connection is created
> ok, but i can't kill the connection (even when we exit the aplication)
>
> I tried:
> ::oAdo:lConnected:=.f.
> ::oAdo:End()
>
> But the connections still on ADS.
> The same happens with the Tables. SQL queries opens the tables but never
> close it.
>
> After some time without access , ADS kils the connection and close the
> Tables.
>
>
> Best regards
> pedro
>
>
>
>
>
>

ADO/ADS question

Publicado: Lun Dic 17, 2007 5:11 pm
por NoName
Pedro,
As ADO implements a common interface for any Database server, I believe the
problem is in ADS ADO client, on contrary, we should have that same problem
with any other database server.
Regards,
--
Ignacio Ortiz de Zúñiga
http://www.xailer.com
"Pedro Faro" <psfaro@shi.pt> escribió en el mensaje
news:47669e00$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> Hi
>
> I noticed that if we access via "ADO " to ADS , the connection is created
> ok, but i can't kill the connection (even when we exit the aplication)
>
> I tried:
> ::oAdo:lConnected:=.f.
> ::oAdo:End()
>
> But the connections still on ADS.
> The same happens with the Tables. SQL queries opens the tables but never
> close it.
>
> After some time without access , ADS kils the connection and close the
> Tables.
>
>
> Best regards
> pedro
>
>
>
>
>
>