TADOConnection and connection lifetime

Hi,

i have 2 problems linked to Connections with ORACLE 9i and ADO (MDAC 2.7 and up).

1) on my application i have made a limited tries login process. First a successful login is done, then after closing the application, i test my "security" process by making x wrong tries that will finally drop the current user. I got then an Oracle error:
ORA-01940: cannot drop a user that is currently connected
I saw in the V$SESSION table that indeed the user i wish to drop is still alive.
How can i kill sooner a connection?

2) Another part of my application is using Global Temporary Tables, design by sessions. When the session is closed, then all the data inside disappear.
When i reconnect from the same user i got a connection that seems to be dirty, i mean keeping inside some data from previous session.
How can i clean the connection when i close it or return it to the pool?


I saw that there is more properties that can be add to a connection string, like:

Connection Lifetime
Connection Reset

I try to use these but without great changes!

I'm using Delphi 5 (update 1), Oracle 9i, MDAC 2.7, on Win2K SP4 workstation.

Any direction of research will be welcomed.

Tia

Laurent
.

Relevant Pages

  • Re: SqlConnection Object in Application Variable OR Session Variable OR open/close
    ... connection object, which means, you are going to have multiple threads ... have an open connection the entire lifetime of a session. ... opening and closing them is relatively inexpensive. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Autodialing for authentication
    ... U can set a connection as "default connectio" by using the Api ... "Pedro Lima" wrote in message ... I have already configured the AutoAdminLogon, DefaultUserName, DefaultDomainName and DefaultPassword registry keys fro winlogon to automate the login process, but I simply cannot automate the dialin process. ...
    (microsoft.public.win2000.ras_routing)
  • Re: Autodialing for authentication
    ... U can set a connection as "default connectio" by using the Api ... "Pedro Lima" wrote in message ... I have already configured the AutoAdminLogon, DefaultUserName, DefaultDomainName and DefaultPassword registry keys fro winlogon to automate the login process, but I simply cannot automate the dialin process. ...
    (microsoft.public.win2000.ras_routing)
  • Re: TADOConnection and connection lifetime
    ... on my application i have made a limited tries login process. ... First a successful login is done, then after closing the application, i test my "security" process by making x wrong tries that will finally drop the current user. ... How can i kill sooner a connection? ... When i reconnect from the same user i got a connection that seems to be dirty, i mean keeping inside some data from previous session. ...
    (borland.public.delphi.database.ado)
  • Re: TADOConnection and connection lifetime
    ... Regarding the connection issue, are you connecting via Listener or is this ... local connection to the database? ... > 1) on my application i have made a limited tries login process. ... i mean keeping inside some data from previous session. ...
    (borland.public.delphi.database.ado)