Connectionstring of ADODB Connection and SqlConnection
Connectionstring for ADODB Connection is OK.
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=DOC2PDFADMIN;Password=doc2pdfadmin;Initial Catalog=DOC2PDFPRD;Data Source=YOURDBSERVER
But if connectionstring for SqlConnection is not OK.
Persist Security Info=False;Integrated Security=SSPI;UID=DOC2PDFADMIN;PWD=doc2pdfadmin;Initial Catalog=DOC2PDFQAS;Data Source=YOURDBSERVER
it will report login failed for MACHINE\USER.
Refer ：http://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqlconnection.connectionstring%28VS.80%29.aspx
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=DOC2PDFADMIN;Password=doc2pdfadmin;Initial Catalog=DOC2PDFPRD;Data Source=YOURDBSERVER
But if connectionstring for SqlConnection is not OK.
Persist Security Info=False;Integrated Security=SSPI;UID=DOC2PDFADMIN;PWD=doc2pdfadmin;Initial Catalog=DOC2PDFQAS;Data Source=YOURDBSERVER
it will report login failed for MACHINE\USER.
Refer ：http://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqlconnection.connectionstring%28VS.80%29.aspx
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/557324/viewspace-1393526/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- 基于ERP／PDM／MES／PCS的数字制造系统信息集成研究
- InstallShield 2010 cracked failed to start
- SQL string to date time
- SQL Server 中文乱码
- Oracle 生成系统数据导入测试系统及smarteam 连接更改
- SQL Server 2008表设计器中无法保存修改
- The certificate must have a private key that is capable of key exchange
- IIS7 COM 类工厂中 CLSID 为 {****} 的组件失败，错误: 80040154
- IIS - Could not load type System.ServiceModel.Activation.HttpModule
- WIN7 IIS: HTTP Error 500.21 - Internal Server Error
