Login issue

Hi,
I have created a web page where I enter my login id, password, and then my
page connects to my database to see if the user is authenticated. If he is,
he can proceed further with other pages.
Please help me to knbow how do I log out a user once logged in? Just reset
the connection to database?
Is there a proper way to do this?
Thanks.Most likely you are tieing your user/pass to the current session so
Session.Abandon()
Session.End()
Curt
"Steven" <anonymous@.discussions.com> wrote in message
news:%23XNsJIRiEHA.3016@.tk2msftngp13.phx.gbl...
> Hi,
> I have created a web page where I enter my login id, password, and then my
> page connects to my database to see if the user is authenticated. If he
> is,
> he can proceed further with other pages.
> Please help me to knbow how do I log out a user once logged in? Just reset
> the connection to database?
> Is there a proper way to do this?
> Thanks.
>
I do not quite understand what your scenario is but it mainly depends on wha
t authentication mechanism you are using. What do you mean by "logged in"''
Do you create a cookie? a session variable' are you using Forms Authenticat
ion'
If using Forms Authentication then you would have to call the SignOut method
System.Web.Security.FormsAuthentication.SignOut()
If using an authentication personalized cookie then you would have to set it
to a date that already passed
myCookie.Expires = DateTime.Now.AddDays(-1)
If using a session variable then you would have to call Session.Abandon or s
et Session("MySession") = Nothing or set a flag in a session variable to ind
icate that the user is not logged in anymore
Anyway IMHO resetting the connection to the database would not make an accur
ate solution. Please detail your scenario
Hope this helps
Alan Ferrandiz Langley
MCDBA, MCT, MSF Practitioner
"Steven" <anonymous@.discussions.com> escribi en el mensaje news:#XNsJIRiEHA.3016@.tk2msftng
p13.phx.gbl...
> Hi,
> I have created a web page where I enter my login id, password, and then my
> page connects to my database to see if the user is authenticated. If he is
,
> he can proceed further with other pages.
> Please help me to knbow how do I log out a user once logged in? Just reset
> the connection to database?
> Is there a proper way to do this?
> Thanks.
>
>
On Mon, 23 Aug 2004 18:36:39 +0530, Steven wrote:

> Hi,
> I have created a web page where I enter my login id, password, and then my
> page connects to my database to see if the user is authenticated. If he is
,
> he can proceed further with other pages.
> Please help me to knbow how do I log out a user once logged in? Just reset
> the connection to database?
> Is there a proper way to do this?
> Thanks.
If you're using cookie, you send a new cookie with the fields cleared.
Tony Cortese
--
Send camera phone photos straight to your online photo album plus a loaded
web hosting package for only $4.95/month - No other Fees
http://www.big-discount-hosting.com
I set up the connection string with the USE AND PASSWORD. I open the
connection and check for errors.
Set Con = Server.CreateObject("ADODB.Connection")
Con.ConnectionTimeout=40
U=Request.Form("USER_ID")
P=Request.Form("Password")
ConStr="Provider=MSDASQL.1;Password=" & P & ";Persist Security
Info=True;User ID=" & U & ";Data Source=XXX"
Con.Open ConStr
If Err.Number<>0 Then
Authorized=0
Else
Authorized=1
End If
Con.Close
Set Con=Nothing
"Steven" <anonymous@.discussions.com> wrote in message
news:%23XNsJIRiEHA.3016@.tk2msftngp13.phx.gbl...
> Hi,
> I have created a web page where I enter my login id, password, and then my
> page connects to my database to see if the user is authenticated. If he
is,
> he can proceed further with other pages.
> Please help me to knbow how do I log out a user once logged in? Just reset
> the connection to database?
> Is there a proper way to do this?
> Thanks.
>