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 but the coding was simple), 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:
main.asp - has the form action
<form name="form1" method="post" action="verify.asp">
verify.asp - has the db connection,
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")
***some session and other unnecessary codes for explanation are ommitted.
If session("employeeid") = "" Then
Now, I just copied the files in the wwwroot of the specified new web server and set the configurations in IIS (e.g. session properties) and ODBC connections...
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... But when i tried checking or browsing it in other pc's ( in internet explorer), session is not working. What makes it worst is that session is not also working when I tried to browse it in the new web server ( in internet explorer). It is very confusing since it is working or 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/default.aspx?scid=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, can I use request.querystring instead?
Thank you all in advance