连接数据库的代码如下:
[code]
CONST SQL_DataBaseName = "abc"
CONST SQL_Username = "sa"
CONST SQL_Password = "dalier"
CONST SQL_DataBaseSource= "192.168.1.56"ConnStr = "Provider = SQLOLEDB;Password = " & SQL_Password & ";Persist Security Info=True;User ID = " & SQL_Username & ";Initial Catalog = " & SQL_DataBaseName & ";Data Source = " & SQL_DataBaseSource & ";Connect Timeout = 15"Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open Connstr
[/code]数据库安装在 一台IP为:192.168.1.56 (非本机) 的电脑上, 得到的错误如下:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server 不存在或拒绝访问。
/shop/website/const.asp, 第 38 行
38行: Conn.Open Connstr我在 192.168.1.56 的机器上用sa账号可以登陆, 防火墙我也关闭了, 杀毒软件也退出了, 请问下,我该还需要检查下什么地方?谢谢!
[code]
CONST SQL_DataBaseName = "abc"
CONST SQL_Username = "sa"
CONST SQL_Password = "dalier"
CONST SQL_DataBaseSource= "192.168.1.56"ConnStr = "Provider = SQLOLEDB;Password = " & SQL_Password & ";Persist Security Info=True;User ID = " & SQL_Username & ";Initial Catalog = " & SQL_DataBaseName & ";Data Source = " & SQL_DataBaseSource & ";Connect Timeout = 15"Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open Connstr
[/code]数据库安装在 一台IP为:192.168.1.56 (非本机) 的电脑上, 得到的错误如下:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server 不存在或拒绝访问。
/shop/website/const.asp, 第 38 行
38行: Conn.Open Connstr我在 192.168.1.56 的机器上用sa账号可以登陆, 防火墙我也关闭了, 杀毒软件也退出了, 请问下,我该还需要检查下什么地方?谢谢!
ping 192.168.1.56 可以ping通么?