Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 8th, 2003, 03:35 AM
Authorized User
 
Join Date: Aug 2003
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default Windows Integrated Security Problem

Hi

I have a problem with my asp application. A user logs on to the system using thier NT username & password. I use Request.ServerVariables("LOGON_USER") to retrieve the username and authenticate to SQL server. I also hold it in a session variable for retrieving their personal data from the database. The problem I have is when they log off the app. The only way I can get the browser to forget them is to close the browser down. I have cleared all session variables etc. Is there a way of forgetting the user without closing IE, or a different way of logging on to the database using Windows Integrated Security.

Thanks
Lbob

 
Old August 8th, 2003, 03:39 AM
Authorized User
 
Join Date: Jun 2003
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi

How about Session.End
 
Old August 8th, 2003, 03:51 AM
Authorized User
 
Join Date: Aug 2003
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Tried thats!

 
Old August 8th, 2003, 07:37 AM
Authorized User
 
Join Date: Aug 2003
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I dont know if the asp application you are using a browser specific one.If its a IE, you can do something like this. Include a iframe with width and height as zero., the source of the page ofcourse contains the session value, Include this iframe in the main page, which means the user can still browse through the whole website, but this page is always present, write a asp page which would clear out all the sessions, call this page in the iframe using onunload() event, so if the user closes the browser or navigates to different website other than your website, his session will be terminated.
You can even control the login by database and call the database routine in the popup to end his session..i didnt try this on netscape as i implemented this for a intranet which was totally IE specific.

Chintu


 
Old August 8th, 2003, 07:44 AM
Authorized User
 
Join Date: Aug 2003
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hmm, I can't guarantee the user will use IE. I've been thinking, woul;d the problem be related to the fact the directory on the server is Integrated Security, because you always get the grey login box?






Similar Threads
Thread Thread Starter Forum Replies Last Post
Integrated Security using Active Directory aldwinenriquez .NET Framework 2.0 1 May 4th, 2007 07:15 AM
Integrated Windows Authentication stonesbg ASP.NET 2.0 Professional 0 March 29th, 2007 04:32 PM
Windows Integrated Security with Java Servlets tbpbanit01 Servlets 0 March 24th, 2004 08:57 AM
Confused about NT Integrated Security VBAHole22 SQL Server 2000 1 June 16th, 2003 12:20 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.