asp+sqlserver平台的配置---总是有问题

Question

driver={SQL Server};database=pubs;server=localhost;uid=sa;pwd=改为Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=localhost;试试

Answer 1

Conn.Open("driver={SQL Server};database=pubs;server=localhost;uid=sa;pwd=");当中的"server= "试一下改成
server=.
或者
server=ip
或者
server=SQLSERVER名称

Answer 2

set conn=server.createobject(ADODB.connetction)
conn.open"provider=SQLOLEDB;datasourct=sql的实例名;uid=sa;pwd=你SQL密码"

Answer 3

set conn=server.createobject(ADODB.connetction)
conn.open"provider=SQLOLEDB;datasourct=sql的实例名;uid=sa;pwd=你SQL密码;database=s数据库名"