{"id":41164,"date":"2016-04-30T08:59:19","date_gmt":"2016-04-30T00:59:19","guid":{"rendered":"http:\/\/v.xyryd.com\/?p=41164"},"modified":"2016-04-30T08:59:19","modified_gmt":"2016-04-30T00:59:19","slug":"iis-%e8%bf%90%e8%a1%8c-net-%e7%a8%8b%e5%ba%8f-%e6%98%be%e7%a4%ba-%e6%9c%aa%e5%9c%a8%e6%9c%ac%e5%9c%b0%e8%ae%a1%e7%ae%97%e6%9c%ba%e4%b8%8a%e6%b3%a8%e5%86%8cmicrosoft-jet-oledb-4-0","status":"publish","type":"post","link":"http:\/\/www.xyryd.com\/41164.html","title":{"rendered":"IIS \u8fd0\u884c .net \u7a0b\u5e8f \u663e\u793a \u672a\u5728\u672c\u5730\u8ba1\u7b97\u673a\u4e0a\u6ce8\u518c\u201cMicrosoft.Jet.OleDb.4.0\u201d\u63d0\u4f9b\u7a0b\u5e8f \u89e3\u51b3\u65b9\u6848"},"content":{"rendered":"<p>\u6700\u8fd1\u6709\u4e00\u4e2a\u9879\u76eeMicrosoft.Jet.OleDb\uff0c\u4e3b\u8981<strong>\u7528\u4e8e\u4eceExcel\u4e2d\u5bfc\u5165\u6570\u636e<\/strong>\uff0c\u5728\u8c03\u8bd5\u9636\u6bb5\u4e00\u76f4\u662f\u6b63\u5e38\u7684\u3002\u4f46\u4e00\u90e8\u7f72\u5230\u5ba2\u6237\u7684\u73af\u5883\u4e2d\uff08Windows Server 2008 R2 + Server 2005 + IIS7\uff09<strong>\u5bfc\u5165\u6570\u636e\u7684\u529f\u80fd<\/strong>\u5c31\u51fa\u73b0\u95ee\u9898\u4e86<\/p>\n<p>\u5176\u9519\u8bef\u5982\u4e0b\uff1a<\/p>\n<p>System.InvalidOperationException: \u672a\u5728\u672c\u5730\u8ba1\u7b97\u673a\u4e0a\u6ce8\u518c\u201cMicrosoft.Jet.OleDb.4.0\u201d\u63d0\u4f9b\u7a0b\u5e8f\u3002<br \/>\n\u5728 System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper&amp; datasrcWrapper)<br \/>\n\u5728 System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)<br \/>\n\u5728 System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)<br \/>\n\u5728 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)<br \/>\n\u5728 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)<br \/>\n\u5728 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)<br \/>\n\u5728 System.Data.OleDb.OleDbConnection.Open()<br \/>\n\u5728 ExcelOperation.ImportFromExcel(String fileName, String strSql)<br \/>\n\u5728 Retiree_ImportData.btnImport_Click(Object sender, EventArgs e)<br \/>\n\u5728 System.Web.UI.WebControls.Button.OnClick(EventArgs e)<br \/>\n\u5728 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)<br \/>\n\u5728 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)<br \/>\n\u5728 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)<\/p>\n<p>\u540e\u6765<strong>\u4e86\u89e3\u5230\u5ba2\u6237\u7684\u64cd\u4f5c\u7cfb\u7edf\u4e3a64\u4f4d\uff0c\u901a\u8fc7IIS\u7a0b\u5e8f\u6c60\u8bbe\u7f6e\u4e2d\u542f\u752832\u4f4d\u5e94\u7528\u7a0b\u5e8f\u9009\u9879\u4e2d\u8bbe\u7f6e\u4e3aTrue\uff0c<\/strong>\u95ee\u9898\u968f\u5373\u89e3\u51b3\u5982\u4e0b\u56fe\uff1a<\/p>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6700\u8fd1\u6709\u4e00\u4e2a\u9879\u76eeMicrosoft.Jet.OleDb\uff0c\u4e3b\u8981\u7528\u4e8e\u4eceExcel\u4e2d\u5bfc\u5165\u6570\u636e\uff0c\u5728\u8c03\u8bd5\u9636\u6bb5\u4e00\u76f4\u662f\u6b63\u5e38\u7684\u3002 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"single-with-sidebar","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[57,58],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/www.xyryd.com\/wp-json\/wp\/v2\/posts\/41164"}],"collection":[{"href":"http:\/\/www.xyryd.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.xyryd.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.xyryd.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.xyryd.com\/wp-json\/wp\/v2\/comments?post=41164"}],"version-history":[{"count":0,"href":"http:\/\/www.xyryd.com\/wp-json\/wp\/v2\/posts\/41164\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.xyryd.com\/wp-json\/wp\/v2\/media?parent=41164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.xyryd.com\/wp-json\/wp\/v2\/categories?post=41164"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.xyryd.com\/wp-json\/wp\/v2\/tags?post=41164"}],"curies":[{"name":"wp","href":"http:\/\/api.w.org\/{rel}","templated":true}]}}