<body>
<%
set cn=Server.CreateObject("ADODB.Connection")
cn.Provider="sqloledb"
ProvStr="Server=COMPUTER;Database=XSCJ;UID=sa;"
cn.Open ProvStr
Response.Write("<br>"&cn.Attributes)
Response.Write("<br>"&cn.CommandTimeout)
Response.Write("<br>"&cn.CursorLocation)
Response.Write("<br>"&cn.DefaultDatabase)
Response.Write("<br>"&cn.IsolationLevel)
Response.Write("<br>"&cn.Provider)
Response.Write("<br>"&cn.Version)
%>
<--密码为空,SQL安装在D盘,最后没有连接上-->
<%
set cn=Server.CreateObject("ADODB.Connection")
cn.Provider="sqloledb"
ProvStr="Server=COMPUTER;Database=XSCJ;UID=sa;"
cn.Open ProvStr
Response.Write("<br>"&cn.Attributes)
Response.Write("<br>"&cn.CommandTimeout)
Response.Write("<br>"&cn.CursorLocation)
Response.Write("<br>"&cn.DefaultDatabase)
Response.Write("<br>"&cn.IsolationLevel)
Response.Write("<br>"&cn.Provider)
Response.Write("<br>"&cn.Version)
%>
<--密码为空,SQL安装在D盘,最后没有连接上-->
服务器名对吗?数据库名对吗?服务器是否是以windows和sqlserver两种方式登录的?
改为
ProvStr="Server=COMPUTER;Database=XSCJ;UID=sa;pwd=''"