The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

最新推荐文章于 2021-07-27 11:22:49 发布

原创最新推荐文章于 2021-07-27 11:22:49 发布 · 1.3k 阅读

1 ·

CC 4.0 BY-SA版权

ASP.NET 专栏收录该内容

2 篇文章

订阅专栏

本文介绍了解决使用C#读取Excel时遇到的The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.错误的方法。通过调整服务器应用程序池设置来允许32位应用程序，可以有效解决此问题。

报错详情

System.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
   at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()

原因及解决方案

用C#读取Excel数据的时候出现错误，把服务器应用程序池设置成允许32位的程序即可。