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

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应用程序池。