Windows server 2008 R2 + IIS 7 + 远程sql server 2012 +ODBC 连接

makala

　　Windows server  2008 R2 + IIS 7 +远程sql server 2012 部署TrackingTool遇到的问题及解决方案
　　
　　http://www.myexception.cn/system/1246171.html
　　------------------------------------
　　ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture
　　mismatch between the Driver and Application
　　解决方法：
　　64位 odbcC:\Windows\SysWOW64\odbcad32.exe  
　　---------------------------------------
　　
　　
　　Server Error in '/' Application.
　　
　　ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT
　　AUTHORITY\ANONYMOUS LOGON'.
　　ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
　　ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT
　　AUTHORITY\ANONYMOUS LOGON'.
　　ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
　　Description: An unhandled exception occurred during the execution of the current web
　　request. Please review the stack trace for more information about the error and where it
　　originated in the code.
　　
　　Exception Details: System.Exception: ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL
　　Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
　　ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
　　ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT
　　AUTHORITY\ANONYMOUS LOGON'.
　　ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
　　
　　Source Error:
　　
　　An unhandled exception was generated during the execution of the current web request.
　　Information regarding the origin and location of the exception can be identified using the
　　exception stack trace below.
　　
　　Stack Trace:
　　
　　
　　[Exception: ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
　　user 'NT AUTHORITY\ANONYMOUS LOGON'.
　　ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
　　ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT
　　AUTHORITY\ANONYMOUS LOGON'.
　　ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute]
　　  TrackingTool.databaseOpr.selectDatabase(String str) in E:\TrackingTool2
　　\rbs\TrackingTool\TrackingTool\databaseOpr.cs:90
　　  TrackingTool.LoginCheck.loginTimeCheck() in E:\TrackingTool2
　　\rbs\TrackingTool\TrackingTool\LoginCheck.cs:42
　　  TrackingTool.Login.loginCt1_LoggingIn(Object sender, LoginCancelEventArgs e) in
　　E:\TrackingTool2\rbs\TrackingTool\TrackingTool\Login.aspx.cs:30
　　  System.Web.UI.WebControls.Login.OnLoggingIn(LoginCancelEventArgs e) +108
　　  System.Web.UI.WebControls.Login.AttemptLogin() +76
　　  System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +101
　　  System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
　　   System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +118
　　  System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +166
　　  System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent
　　(String eventArgument) +10
　　  System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String
　　eventArgument) +13
　　  System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
　　  System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean
　　includeStagesAfterAsyncPoint) +1565
　　
　　 解决方法：参考http://www.myexception.cn/system/1246171.html
　　
报错：错误代码 0x800700b7 配置错误定义了重复的“system.web.extensions/scripting/scriptResourceHandler”节

这个问题原因在于window7的IIS默认用的是ASP.NET v4.0应用程序池。
　　
　　
　　
　　
　　
　　
         版权声明：本文为博主原创文章，未经博主允许不得转载。