Hi guys, I just want to consult something and this has been my problem for almost half a year, wheoooo...
Here's the situation, we have an existing intranet application for HRD. It uses session and database login authentication and it is working properly in the existing web server (fyi:I was not the one who developed the application), now I was tasked to transfer the application to another server that will act as the new web server.
Here are the important codes for the initial asp pages:
1. main.asp - has the form action,
<form name="form1" method="post" action="verify.asp">
2. verify.asp - has the db connection and,
id = Request.form("employeeid")
pwd = Request.form("password")
session("employeeid") = id
if id = "" or pwd = "" then
set my_conn= Server.CreateObject("ADODB.Connection")
set rscheck = my_conn.Execute ("Select * from Employee where EmpID='" & id & "' and Password='" & pwd & "'")
if rscheck.eof then
'invalid password and redirect to error.asp
session("employeeid") = rscheck("EmpID")
session("name") = rscheck("NickName")
session("fullname") = rscheck("FirstName") session("password") = rscheck("Password")
If session("employeeid") = "" Then
'Response.Write("Value: " & Session("employeeid"))
Now, I just copied the files in the wwwroot of the specified new web server (main.asp, verify.asp and home.asp, from the old server to the new server since they are the same files and were supposed to work and function alike from the old server to the new server...) and set the configurations in IIS (e.g. session properties), ODBC connections, etc...
All I have to do is to check if it works properly and since I first checked or browsed the web application in internet explorer in the old server, it works! session is working alright (it does shows the session, Value: 6745-3, which is the format of the employee id)... But when i tried checking or browsing the web application in internet explorer in at least 4 other client pc's, session is not working, I'm being redirected to mainend.asp (codes in home.asp - Response.Redirect "mainend.asp"). What makes it worst is that session is not also working when I tried to browse it in internet explorer in the new web server.
It is very confusing since the session is working in the old web server (in internet explorer, as client pc since the files are pointed to the new web server) but it is not working in other pc's and most especially in the new web server.
I've tried configuring the necessary configurations in IIS (application configuration - enable session state), Internet Explorer (cookies setting), global.asa (default codes), but still it is not working (I've read resources and advices from this article from microsoft, http://support.microsoft.com/defaul...kb;EN-US;175662
Our last resort was to reformat the web server and install default configuration for IIS and others, and to no avail, it's still not working.
I would really appreciate any advice and help since this problem is giving me lots of headaches and I'm in the process of developing other applications with database login authentications using session. What are my options?
Thank you all in advance.