Re: TADOConnection and connection lifetime

Hi,

i'm connecting via Listener (TNSnames.ora).


Michael Jacobs wrote:

Regarding the connection issue, are you connecting via Listener or is this local connection to the database?

<user@xxxxxxxxxxxxxx> wrote in message news:429c68bf$1@xxxxxxxxxxxxxxxxxxxxxxxxx

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

  • 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. ... 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: 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
    ... 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)
  • Re: APPN Connection z/os - AHHC / LLC2.
    ... implied that you session stopped for a while and then continued. ... the ANNC link is a type 2.1 connection. ... I would suggest trying to limit the request unit size used over the type 2.1 ... MAXDATA operand when defining a PU statement for an adjacent link station ...
    (bit.listserv.ibm-main)