Login / Logout

[adshocker]

Hi all,

I've created a Login feature of my Application. The Login Form contains the usual usernameTextbox, passwordTextbox, okButton, cancelButton.

on my okButton, i placed there the codes to make the oracleConnectionString using the oracleConnectionStringBuilder and it works ok.

now the problem is on my Main Form, I have a Log Out Menu/Button. what codes do i need to place here.

also, i would just like to say that my application uses a typed dataset. not sure if this is relevant information on my issue.

the codes i have so far

Dim _frmLogin As New frmLogin
Dim orclBuilder As New OracleConnectionStringBuilder()

With orclBuilder
.Clear()
End With

My.Settings.Reset()
My.Settings.Item("xeConnectionString") = orclBuilder.ConnectionString

_frmLogin.Show()
Me.Dispose()
Me.Close()

i noticed that this code does not kill the oracle session created when i logged in.
how do i close the typed connection and kill the oracle session?
please help... thanks.

 

[adshocker]

i've learned that pooling is responsible as to why my session stays even after closing the connection. others recommend to have connection pooling set to true but the problem i'm having is that after i reset a password for a particular user that has created a session, when i ask that user to logout and re-log, the user will be able to login with both passwords (old and new password). i'm assuming this is because the session before the password reset is the one still being used. so how do i create a log out feature that will terminate the session of the user?

anyone have any ideas?

thanks.