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

最新推荐文章于 2019-08-05 10:55:00 发布

ChaoYang0502

最新推荐文章于 2019-08-05 10:55:00 发布

阅读量1.3k

点赞数

分类专栏： ASP.NET相关网站文章标签： Microsoft.Jet.OLEDB

本文链接：https://blog.csdn.net/ChaoYang0502/article/details/40864309

版权

ASP.NET相关网站专栏收录该内容

32 篇文章 1 订阅

订阅专栏

ASP.NET 做Excel导入操作时，会用到'Microsoft.Jet.OLEDB.4.0'，但因为微软的jet.oledb.4.0 只支持x86，所以运行在64位操作系统下会报下面错误。

Server Error in '/' Application.

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()

针对此问题，解决方案：

IIS7应用程序池上，右击选择 ‘Advanced Settings’ ，并且设置 ‘Enable 32-bit Applications’ to True.