能否用adodb.connection 使用windows身份验证登录方式连接SQL?该如何解决
能否用adodb.connection 使用windows身份验证登录方式连接SQL?
请问VB6里用adodb.connection可不可以使用windows身份验证登录方式连接SQL?
这样就无需去找SQL的sa的密码了.
------解决方案--------------------
1 "Persist Security Info=False;Integrated Security=true;Initial Catalog=AdventureWorks;Server=MSSQL1 "
2 "Persist Security Info=False;Integrated Security=SSPI;database=AdventureWorks;server=(local) "
3 "Persist Security Info=False;Trusted_Connection=True;database=AdventureWorks;server=(local) "
请问VB6里用adodb.connection可不可以使用windows身份验证登录方式连接SQL?
这样就无需去找SQL的sa的密码了.
------解决方案--------------------
1 "Persist Security Info=False;Integrated Security=true;Initial Catalog=AdventureWorks;Server=MSSQL1 "
2 "Persist Security Info=False;Integrated Security=SSPI;database=AdventureWorks;server=(local) "
3 "Persist Security Info=False;Trusted_Connection=True;database=AdventureWorks;server=(local) "