bap skydive mv解读:Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'

来源：百度文库编辑：高校问答时间：2024/05/10 08:37:00

<%
set objconn = server.createobject("adodb.connection")

objconn.open "trade","sa","sa"
if objconn.state=1 then
response.write "objconn与数据库连接成功"
objconn.close
else
response.write "objconn与数据库连接失败"
end if
set objconn=nothing
%>

应该这样写

set objconn = server.createobject("adodb.connection")

objconn.Open "Provider=SQLOLEDB; Data Source=localhost; Initial Catalog=trade; User Id=sa; Password=sa"
if objconn.state=1 then
response.write "objconn与数据库连接成功"
objconn.close
else
response.write "objconn与数据库连接失败"
end if
set objconn=nothing

晕数据库连接字串都没有给定 objconn怎么可能没有错

Microsoft OLE DB Provider for ODBC Drivers (0x80040E4E) Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Microsoft OLE DB Provider for SQL Server 求救~~ Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Microsoft OLE DB Service Components 错误 '8000ffff' Microsoft OLE DB Service Components 错误 '8000ffff' Microsoft OLE DB Provider for ODBC Drivers (0x80040E2F) Microsoft OLE DB Provider for ODBC Drivers (0x80004005)