大家都知道asp中连接sql server时连接字符串有多种写法：以前我通常用
dsnstr="dsn=DNS_Name;uid=sa;pwd="这种形式，今天偶尔改写成dsnstr="Provider=sqloledb;Data Source=Server_Name;Initial Catalog=DB_Name;Integrated Security=SSPI;"出错
Integrated Security=SSPI换成user id=sa;password=;则没问题
dsnstr="Driver={SQL Server};Server=Server_Name;Database=DB_Name;Trusted_Connection=yes;"
也不行
我是不是忘了设什么东西了？
---------------------------------------------------------------
set con = server.createobject("ADODB.connection")
set rs = server.createobject("ADODB.recordset")
con.open "Driver={SQL SERVER};SERVER=Server_name;uid=User_name;pwd=Password;database=database_name"
sql = "select * from table_name"
rs.open sql,con,3,3
---------------------------------------------------------------
Integrated Security=SSPI 说明你的数据库不支持这样的验证方式