asp 连接数据库sqlserver 2008问题

[Pavel_迟]

连接字符串如下
Set conn=Server.CreateObject("ADODB.Connection")
connstr="Driver={SQL Server};SERVER=127.0.0.1/SQLSERVER2005;UID=sa;PWD=1234;DATABASE=TopnewGXL"


错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server 不存在或访问被拒绝
/SQLSERVER2005/upload.asp, 第 14 行


浏览器类型：
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET4.0C; .NET4.0E; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; 360SE)

网页：
GET /SQLSERVER2005/upload.asp

时间：
2011年11月4日, 15:24:15

[csdn_aspnet]

public Sql_server_addr,Sql_user,Sql_password,Sql_database
Sql_server_addr = "192.168.0.234" '数据库服务器地址
Sql_user = "sa" '用户
Sql_password = "606" '密码
Sql_database = "ChengJi" '数据库名
public constr '链接字符串
connstr="PROVIDER=SQLOLEDB;DATA SOURCE=" & Sql_server_addr & ";database=" & Sql_database & ";User Id=" & Sql_user & ";PASSWORD=" & Sql_password & ";"

[hookee]

sql server端口要配置到1433

connstr="Provider=SQLNCLI;Server=127.0.0.1;Database=TopnewGXL;Uid=sa;Pwd=1234;"