2. ASPRunnerPro General questions
  3. Single sign on in 6.1
This topic is locked

Single sign on in 6.1

 		7/2/2009 5:26:50 PM
ASPRunnerPro General questions
T
 Tim author

Hello,
In the "Login page: Before process" event I have the following code:
strUN = "Select StaffID From Staff Where WinLog = '" & Request.ServerVariables("LOGON_USER") & "'"

Set objRS = Server.CreateObject("ADODB.Recordset")

objRS.Open strUN, dbConnection

SESSION("UserID") = objRS("StaffID")

objRS.Close : set objRS = Nothing
response.redirect "menu.asp"
This works in ver 6.0. In 6.1 I get a 500 error. If I change the redirect to something outside the app (like google) it works. If I rem out the redirect and do:
response.write Request.ServerVariables("LOGON_USER")

response.write Session("UserID")
I get the proper data displayed. It's just when I attempt to redirect to a page "inside" the app that it fails. I removed the redirect and logged in via the login form and got in fine. I then went to the admin area and verified I am set up as Admin with access to all tables, and that I could access all pages.
Let me know if you need more info.

Thanks for your help.

Tim
J
 		Jane 7/3/2009

Tim,
to say what's happening I need the original error message.

IE hides error message and show its own.

You should go to the Tools --> Internet Options --> Advanced in the IE (Internet Explorer) and uncheck "Show friendly HTTP error messages" option.

Then reproduce your error and post full error message.
T
 		Tim author 7/3/2009

Jane,
Thanks for the IE tip! I wondered why I wasn't getting better error messages. This should help with my other topic too. Here is the error:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'Session(...)(...)'
/SewardMaintenance/include/commonfunctions.asp, line 1828
Thanks,

Tim
J
 		Jane 7/6/2009

Tim,
It's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.
T
 		Tim author 7/6/2009

Jane,
When I attempt to upload this one to the Demo account I get - "Error: Can't get database information."
FYI - I am using SQL 2005.
Please let me know what's next.

Thanks,

Tim
J
 		Jane 7/7/2009

Tim,
please zip and send generated files, project file and database to support@xlinesoft.com for investigation.