473,326 Members | 2,732 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Getting error "500 internal server error" in ASP Win Server 2008

33
Hello,

I have an application developed in ASP with Access as back end. The code starts as follows

Expand|Select|Wrap|Line Numbers
  1. <%@ Language=VBScript %>
  2. <%
  3. set cn=nothing
  4. set rs=nothing 
  5. set rsUser=nothing
  6. set rsVisit=nothing
  7.  
  8. set cn=server.createobject("ADODB.connection")
  9. set rs=server.createobject("ADODB.recordset")
  10. set rsUser=server.createobject("ADODB.recordset")
  11.  
  12. 'if cn.state=adstateopen then cn.close
  13. Connectstr = "DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\inetpub\wwwroot\payment\empdata.accdb;UID=;PWD="
  14.  
  15.  
  16. cn.open connectstr
  17.  
  18.  
  19. Response.Write Request("connectstr")
  20. dim loginname, pwd
  21.  
  22. userid = trim(Request.Form.Item("txtLogin"))
  23. pwd = trim(Request.Form.Item("txtPwd"))
  24.  
  25. Response.Write Request("userid")
  26.  
  27.  
  28. if Request("userid") <> "" then
  29.     empcode = Request("userid")
  30. end if
  31.  
  32. if userid <> "" then
  33.     sqlUser = "Select Password from employee where empcode = " & userid
  34.     rsUser.Open sqlUser, cn, adOpenStatic
  35. end if
  36.  
  37. 'Response.Write Request("FName")
  38. 'Response.Write (userid)
  39.  
  40.  
  41. if Request("userid") = "" then
  42.     if not rsUser.EOF then
  43.         if pwd <> trim(rsUser(0)) then
  44.             Response.Redirect("default.htm")
  45.             request("txtLogin").setfocus                
  46.         end if
  47.     else
  48.         Response.Redirect("Invalid.htm")
  49.     end if
  50. else
  51.     if trim(Request.Form.Item("txtPwdOld")) <> pwd then
  52.         Response.Redirect("Invalid.htm")
  53.     end if
  54. end if
  55.  
It works fine in the system (windows 7) where it was developed. When I installed the same in the server (Windows Server 2008), the login html page is displayed. After giving the password, the following error is displayed:

"500 internal server error - There is a problem with the resource you are looking for"

Can anybody help me in resolving this issue.
Thanks in advance

Matsam
Jun 25 '13 #1
0 1190

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Sam | last post by:
Guys facing a strange problem any clue would really rescue me.. i am using a ASP application with following things Server : Intel Xeon (TM) CPU 2GHz, 2GB RAM, 136GB HDD OS : Windows 2000...
0
by: Terry Ladouceur | last post by:
I have installed VB.NET 2003 on my machine. Whenever I write a web service or web page of any type that uses ADO to connect to a SQL Database I get a HTTP Error 500 Internal Server Error. I have...
5
by: George | last post by:
I'm getting an internal compiler error from Visual C++ .NET 2003 when I'm using managed extensions. Here is the error. Generating Code... c:\development\icu\source\common\uhash.c(869) : fatal...
8
by: Rod | last post by:
I have been working with ASP.NET 1.1 for quite a while now. For some reason, opening some ASP.NET applications we wrote is producing the following error message: "The Web server reported...
0
by: kuladeep.mohan | last post by:
Hi I am trying to consume a web service from asp.net web page through HTTP POST method and I am getting the following error message "System.Net.WebException: The remote server returned an error:...
0
by: wardley | last post by:
Browse Internal URL through Server from Web Address Not sure how to ask this.. but, I have internal IPs that have web content. That I want to be able to browse from a real world web address. ...
4
by: Barnali85 | last post by:
Hi all, I am getting "The remote server returned an error: (500) Internal Server Error" exception. I have written the following code in VS.NET2005 using C# : WebRequest wr =...
1
by: kigoobe | last post by:
Hi friends, I'm having three queries that works perfectly ... SELECT ib.id as id, ib.titre as title, ib.date_expire as date_fin, ib.created_at as date_creation, eb.content as content, '' FROM...
0
by: Steve | last post by:
Hi guys, I've recently upgraded a test TFS 2005 server to TFS 2008. On the whole, the upgrade has gone smoothly, but I'm having a few issues, one of which is as follows: One of my test...
2
by: bandy | last post by:
Hi there sorry If I posted this thread under wrong head. When I am trying to run my site I am getting error as Internal Server Error, but when I refresh page , i get result properly. I don't...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.