Re: TADOConnection and connection lifetime

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

  • Re: Database interactions dont fire from Application_Start in Global.asax?
    ... tell that it's not updating my database. ... session ID in the database to prevent multiple logins. ... 'Creates the database's Connection object ... 'Tells the command object to use the connection above ...
    (microsoft.public.dotnet.framework.aspnet)
  • 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)
  • Re: Remote desktop deadlock on XP SP2
    ... the TS connection is frozen, even if I specify a wait timeout. ... TermSrv.dll creates a new session for the purpose of displaying the logon ... lives on a DPC routine for the network miniport ... the network packets are encapsulated and decapsulated in UDP. ...
    (microsoft.public.win32.programmer.kernel)
  • Re: JES-APPL
    ... Then there has been a session initiation request - which can only happen over an available session path - this isn't any of your flaky IP, ... Unless the NJE application on the AS/400 has consistently been caught in the middle of being activated in some way - highly unlikely I would expect - this is not a timing problem. ... Since the connection is necessarily in place, there is no problem with the connection - just in case a modem is involved - which, given a "switched" definition is used, is not impossible, but unlikely. ...
    (bit.listserv.ibm-main)
  • Re: Servlet and row-level lock
    ... > in which users can select orders from a DB2 database, modify the order, or ... the class mantains a Connection to the database and it's responsible ... > with a select for update, saving on a session the instance, and redirect to ...
    (comp.lang.java.databases)