asp 连接sql server数据失败 乱码
源代码如下:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!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" />
<title>无标题文档</title>
</head>
<body>
<%
' 学生登录,添加管理员登录
'sql="select name from iox.dbo.info where name='"&uname&"' psw='"&upsw&"' "
Dim Conn, Connstr
Dim strServer, strUid, strPwd, strDB
strServer = "localhost" 'SQL数据库服务器地址
strUid = "sa" '数据库用户名
strPwd ="1234"'数据库密码
strDB = "test" '数据库名
'On Error Resume Next
Set Conn = Server.CreateObject("ADODB.Connection")
Connstr = "driver={sql server};server="&strServer&";uid="&strUid&";pwd="&strPwd&";database="&strDB
Conn.Open Connstr
Dim rs
Dim sql
Dim cmd
'sql="select name from iox.dbo.info where name='"&uname&"'&psw='"&upsw&"'"
sql="select * from test.dbo.list"
Set rs=Server.CreateObject("ADODB.Recordset")
'Set cmd=Server.CreateObject("ADODB.Command")
rs.ActiveConnection=Conn
rs.CursorType=1
rs.LockType=1
rs.Open sql
if rs.EOF Then
Alert("输入的用户名和密码错误!")
GoBack()
Response.End
else
response.Write("heelo ,ht")
rs.close()
Set rs=Nothing
Conn.close()
Set Conn=Nothing
'response.redirect("memWelcome.html")
End if
%>
</body>
</html>
返回错误信息如下:
Microsoft OLE DB Provider for ODBC Drivers ??? '80004005'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server ???
/log.asp??? 23
如何解决啊?