连接SQL数据库出现错误,请达人帮忙下
<%@ language=vbscript %><html>
<head>
</head>
<body>
<%
dim strsql
dim conn,studentrs
dim strconn
dim connstr
set conn=server.createobject("adodb.connection")
set studentrs=server.createobject("adodb.recordset")
connstr="provider=SQLOLEDB;data source={HUAYUREI-2CB546};initial catalog=student"
conn.open connstr
studentrs.open "select * from student1",conn
do while not studentrs.eof
respones.write "<tr>"
respones.write "<td>" & studentrs.fields("name") & "</td>"
respones.write "<td>" & studentrs.fields("sex") & "</td>"
respones.write "<td>" & studentrs.fields("birthday") & "</td>"
respones.write "<td>" & studentrs.fields("enterday") & "</td>"
respones.write "</tr>"
studentrs.movenext
loop
response.write "</table>"
studentrs.close
set studentrs=nothing
%>
</body>
</html>
这是我写的程序,学习阶段主要看看是否能成功连接数据库,错误是14行给出的是无效信息,是不是第13行给出的连接数据库信息有错误?还是那里的问题?请达人能帮我找下原因
