asp连接sql server 2008数据库

Question

asp连接sql server 2008数据库

Answer 1

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 & ";"

你的连接字符串写错了！