SQL Server 外围应用配置器—服务和连接外围配置—database englie—远程连接—启用(远程连接的TCP/IP和named pipes) SQL Server Configuration Manager—SQL2005网络配置—启用TCP/IP和named pipes
<% dim fconnstr,fTempConn dim bconn,bstr fconnstr = "driver={SQL Server};server=(local);UID=sa;PWD=;database=hlw360bbs" Set fTempConn = Server.CreateObject("ADODB.Connection") fTempConn.Open fConnStr
SQL Server Configuration Manager—SQL2005网络配置—启用TCP/IP和named pipes
dim fconnstr,fTempConn
dim bconn,bstr fconnstr = "driver={SQL Server};server=(local);UID=sa;PWD=;database=hlw360bbs"
Set fTempConn = Server.CreateObject("ADODB.Connection")
fTempConn.Open fConnStr
bstr = "driver={SQL Server};server=(local);UID=sa;PWD=;database=blog"
Set bconn = Server.CreateObject("ADODB.Connection")
bconn.Open bstr
%>这是我的连接字符串
把local换为
.或机器名