sql连不上是怎么回事?
<%
option explicit
dim startime,db,rs,rs_s,rs_s1
startime=timer()
'---------------------数据库类型及路径定义---------------------
dim conn,connstr,strSQLServerName,strSQLDBUserName,strSQLDBPassword,strSQLDBName
'----------------------------------------------------------
strSQLServerName = "kk" '服务器名称或地址
strSQLDBUserName = "administrator" '数据库帐号
strSQLDBPassword = "" '数据库密码
strSQLDBName = "shop40" '数据库名称
'----------------------------------------------------------
Set conn = Server.CreateObject("ADODB.Connection")
connstr = "Provider=SQLOLEDB.1;Persist Security Info=False;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"
conn.Open connstr
%>
以上是我从网上下载的整站程序,但提示错误如下:
错误类型:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
/net/shop_sql_40/shop/conn.asp, 第 18 行
浏览器类型:
Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
页:
GET /net/shop_sql_40/shop/index.asp
大家看看怎么回事