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博客 ” ,链接:http://blog.itpub.net/557324/viewspace-1393526/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/557324/viewspace-1393526/