Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 3.51 Driver][mysqld-4.0.21-nt]Got error 127 from table handler
/Trial/dbase_admin/asp/login.asp, line 108
LINE 108:
Set RS=Con.execute("Select * from admin_login where admin_username='"& username &"' and admin_password='"& password & "'")
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 3.51 Driver][mysqld-4.0.21-nt]Got error 127 from table handler
/Trial/dbase_admin/asp/login.asp, line 108
Code:
<%Response.Buffer="true"%>
<html>
<head>
<META NAME="Owner" CONTENT="Volaro Ltd">
<META NAME="Copyright" CONTENT="2004 - Volaro Ltd">
<META NAME="Author" CONTENT="Volaro Ltd">
<title>Database Administration</title>
<script language="javascript">
function validate(df)
{
if(df.username.value=="")
{
alert("Please insert The Name of the Database")
df.username.focus();
return false;
}
if (df.password.value=="")
{
alert("Please insert a password")
df.password.focus();
return false;
}
return true;
}
</script>
</head>
<body bgcolor="#f5f5f5" link=black alink=red vlink=black>
<%
sub loginform()%>
<br>
<br>
<Form Name="form" Method="Post" action="login.asp" onsubmit="return validate(document.form)">
<table width="400" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="16"><img src="/beaver/asp/images/top_lefbb.gif" width="16" height="16"></td>
<td height="16" background="/beaver/asp/images/top_midbb.gif"><img src="/beaver/asp/images/top_midbb.gif" width="16" height="16"></td>
<td width="24"><img src="/beaver/asp/images/top_rigbb.gif" width="24" height="16"></td>
</tr>
<tr>
<td width="16" background="/beaver/asp/images/cen_lef.gif"><img src="/beaver/asp/images/cen_lef.gif" width="16" height="11"></td>
<td>
<Table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr bgcolor="#CCCCCC">
<Td colspan="3" align="Left"><div align="center"><Font face="verdana" size="2" color="Black"><b>Fares Admin Access </b></font></div></td>
</tr>
<tr>
<td width="35%" height="28">
<div align="right"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Username</font></div>
<div align="right"></div></td>
<Td colspan="2"> <Input Name="username" Type="text" id="username"></td>
</tr>
<tr>
<td>
<div align="right"><Font face="verdana" size="-1" color="Black">Password</font></div></td>
<Td colspan="2"> <Input Name="password" Type="password" id="password"></td>
</tr>
<tr>
<td align="Right"> </td>
<td width="42%" align="Right">
<div align="right">
<Input Type="Submit" name="Submit2" Value="Submit">
</div></td>
<td width="23%" align="Right"> </td>
</tr>
</table></td>
<td width="24" background="/beaver/asp/images/cen_rigBB.gif"><img src="/beaver/asp/images/cen_rigBB.gif" width="24" height="11"></td>
</tr>
<tr>
<td width="16" height="16"><img src="/beaver/asp/images/bot_lefbb.gif" width="16" height="16"></td>
<td height="16" background="/beaver/asp/images/bot_midbb.gif"><img src="/beaver/asp/images/bot_midbb.gif" width="16" height="16"></td>
<td width="24" height="16"><img src="/beaver/asp/images/bot_rigbb.gif" width="24" height="16"></td>
</tr>
</table>
</form>
</td></tr>
</table>
<Script Language="javascript">
document.form.username.focus();
</script>
<%end sub%>
<!--Login Part -->
<%
username=Trim(Request.Form("username"))
password=Trim(Request.Form("password"))
if username="" and password="" then
call loginform()
else%>
<!--#Include File="connection.asp"-->
<%
dim flag,flag1
flag="true"
flag1="true"
if username<>"" and password<>"" then
Set RS=Con.execute("Select * from admin_login where admin_username='"& username &"' and admin_password='"& password & "'")
if not rs.eof then
Response.Cookies("dbase_name")=Trim(RS("admin_username"))
Response.Cookies("comp_code")=Trim(RS("company_id"))
Set rs1=con.execute("Select company_name from company where company_id='"& rs("company_id") &"'")
if not rs1.eof then
Response.Cookies("comp_name")=Trim(RS1("company_name"))
end if
rs1.close
else
flag="false"
flag1="true"
end if
rs.close
Set Rs=nothing
Set Con=Nothing
else
flag="false"
flag1="false"
end if
%>
<Table align="center" width="95%">
<Tr>
<%
if flag="false" and flag1="false" then
'//if Request from prev page was incomplete then%>
<td align="center"><font face="verdana" size="1" color="red"><B>Please enter the username or password correctly</b></font></td>
<%elseif flag="false" and flag1="true" then
'//if username /password were invalid then%>
<td align="center"><font face="verdana" size="1" color="red"><B>Invalid username or password.<br> Try Again...! </b></font></td>
<%call loginform()
else
'//if Login was successful then
Response.Redirect "member.asp"
end if%>
</tr>
</Table>
<%end if%>
<!-- Login End-->
</td></tr>
</table>
</body>
</html>
LINE 108:
Set RS=Con.execute("Select * from admin_login where admin_username='"& username &"' and admin_password='"& password & "'")