ASP kode virker ikke under IIS 7.5
Hej jeg sidder og roder lidt med et gammelt login script til en hjemmeside men når jeg prøver at logge ind skriver den detteAn error occurred on the server when processing the URL. Please contact the system administrator.
If you are the system administrator please click here to find out more about this error.
Men classic asp er installeret på serveren og der MYSQL og mysql-connector-odbc installeret.
koden ser sådan her ud
Kode start
________________________________________________
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<style type="text/css">
FORM {
DISPLAY: inline
}
.style1 {
font-weight: bold;
background-color: #FFFFFF;
}
.style2 {
background-color: #FFFFFF;
}
</style>
<title>Xbox</title>
</head>
<body>
<%
if request ("mode") = "login" then
' Opretter forbindelse til databasen
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=db.guf4you.dk;DATABASE=web1785_1;USER=web1785;PASSWORD=1949491m41;OPTION=3;"
'ændre imput
Brugernavn = Trim(Replace(Request.Form("Brugernavn"),"'","''" ))
Password = Trim(Replace(Request.Form("Password"),"'","''" ))
rsSQL = "SELECT * FROM login where brugernavn = '" & Brugernavn & "' and Password = '" & Password & "'"
' hvis brugeren var i databasen
set rs = Conn.execute(rsSQL)
If Not (rs.BOF Or rs.Eof) Then
Session("Id") = rs("Id")
session("Member") = True
Response.redirect "xbox.asp"
Else
'
' Hvis brugeren ikke var i databasen
Response.redirect "loginfejl.asp"
End If
' Lukker forbindelse til databasen
Conn.Close
Set Conn = Nothing
End if
%>
<table border="0" width="100%" id="table12" bgcolor="#E9E9E9">
<tr>
<td>
<html>
<body>
<form method="post" action="default.asp">
<table border="0" cellspacing="0" width="228" height="125" class="style2">
<tr>
<td width="71" height="40" align="right"><p><b><font size="1" face="Verdana">Brugernavn:</font></b></td>
<td width="153" height="40">
<p align="center"><font face="Verdana" size="1"><input type="text" name="Brugernavn"></font></td>
</tr>
<tr>
<td width="71" height="25" align="right" class="style1"><font size="1" face="Verdana">Password:</font></td>
<td width="153" height="25">
<p align="center"><font face="Verdana" size="1"><input type="password" name="Password"></font></td>
</tr>
<font face="Verdana" size="1">
<input type="hidden" Name="Mode" Value="login"></font></td>
<tr>
<td width="71" height="25" align="right"> </td>
<td width="153" height="25">
<font face="Verdana" size="1"><input type="submit" value="Login"></font></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
________________________________________________
kode slut
Man kan selv prøve her http://admin.privat-ferie.dk
Håber nogen har et godt bud på hvad jeg gør forkert
