asp链接sql serve
新建了一个网站,用的IIS,在没有用数据库之前可以正常使用,加入了sql serve数据库之后就一直显示Internal Server Error,
<html>
<head>
<title>学籍管理系统</title>
<script type="text/javascript">
function login()
{
var content1 = document.getElementById("un");
var content2 = document.getElementById("pw");
var username=content1.value;
var password=content2.value;
var xmlhttp;
if (content1.value.length==0||content2.value.length==0)
{
document.getElementById("txtHint").innerHTML="kong";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("get","testsql.asp"+username+"&p="+password,true);
xmlhttp.send()
}
</script>
</head>
<style>
#warp {
position: absolute;
width:500px;
left:70%;
top:70%;
margin-left:-250px;
margin-top:-100px;
}
</style>
<body>
<div id=warp stytle="align:center">
<form action="">
账号:
<input type="text" id=un name="username" />
<br />
密码:
<input type="password" id=pw name="password" />
<br />
<input type="button" value="登录" onclick="login()">
</form>
<p id="txtHint"></p>
</div>
</body>
</html>
ASP只写了一个很简单的连接数据库操作
<%@ language="javascript"%>
<html>
<body>
<%
var conn,strsql
Set conn = Server.CreateObject("ADODB.Connection");
strsql="PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=sa;PWD=1234567;DATABASE=xj"
conn.Open strsql
Response.Write( "数据库连接")
%>
</body>
</html>
测试后一直出现Internal Server Error,点击错误显示xmlhttp.send()这一行有错误,请问这到底是怎么回事儿呢?