UC知道ASP的论坛改SQL数据库后出现的错误
来源：百度知道 编辑：UC知道 时间：2024/05/17 04:10:59
错误内容为：
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
ODBC 驱动程序不支持所需的属性。
/bbs/topiclist.asp，行 111
行111的代码为最后一行:
if action="good" then
sql="select * from topic where bd="&bd&" and type=1 order by top desc,edittime desc"
else
sql="select * from topic where (bd="&bd&" or top=2) and type<>3 order by top desc,edittime desc"
end if
set rs = server.createobject("adodb.recordset")
pagesetup=checknum(application(prefix&"topiclistpage"))
行111：rs.Open sql,conn,1
驱动没有错呀
ConnStr = "Driver={SQL Server};Server=" & StrServerName & ";Database=" & StrDBName & ";Uid=" & StrUid & ";Pwd=" & StrPwd & ";"
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
ODBC 驱动程序不支持所需的属性。
/bbs/topiclist.asp，行 111
行111的代码为最后一行:
if action="good" then
sql="select * from topic where bd="&bd&" and type=1 order by top desc,edittime desc"
else
sql="select * from topic where (bd="&bd&" or top=2) and type<>3 order by top desc,edittime desc"
end if
set rs = server.createobject("adodb.recordset")
pagesetup=checknum(application(prefix&"topiclistpage"))
行111：rs.Open sql,conn,1
驱动没有错呀
ConnStr = "Driver={SQL Server};Server=" & StrServerName & ";Database=" & StrDBName & ";Uid=" & StrUid & ";Pwd=" & StrPwd & ";"
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
ODBC 驱动程序不支持所需的属性。
/bbs/topiclist.asp，行 111
驱动都错了.这个驱动是ACCESS的
连接SQL应该是 DRIVER={SQL SERVER}