System.InvalidOperationException：'Microsoft.Jet.OLEDB.4.0'提供程序未在本地计算机上注册 [英] System.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine

问题描述

我在Win 2003服务器上运行ASP .NET 2.0应用程序。 ASP .NET应用程序调用也在同一服务器中托管的Web服务。

我使用过Jet.OLEDB.4.0在客户端应用程序以及Web服务中访问Excel电子表格。当我访问网页并提交我的webservice请求时，我得到的是"System.InvalidOperationException：'Microsoft.Jet.OLEDB.4.0'提供程序未在本地计算机上注册"来自webservice的错误。但我没有从调用Web服务的客户端应用程序中收到任何错误。

当用户在网页中选择excel电子表格并提交文件背后的代码时，稍微解释一下这个功能将文件上载到服务器，打开它并验证列名称，并提供如何使用第一个数据行为用户处理数据的预览。如果发现任何错误，则会引发错误。如果预览良好且列很好，那么当用户点击确认按钮时，它会调用webservice来处理文件中的数据。

我不明白我是如何得到"System.InvalidOperationException：'Microsoft.Jet.OLEDB.4.0'提供程序未在本地计算机上注册的"来自web服务的错误，而不是来自网页背后的代码，即使它们都在sam机器中。

如果我问一个小问题，我很抱歉。我一直在研究ASP .NET。

解决方案

Web服务是作为64位进程运行的吗？这将是一个问题，因为目前不支持64位Jet OLEDB提供程序。

I'm running a ASP .NET 2.0 application in Win 2003 server. ASP .NET application invokes a webservice which is also hosted in the same server.

I have used  Jet.OLEDB.4.0 both in the client application as well as in the webservice to access Excel spreadsheet. When I access the webpage and submit my webservice request I'm getting the "System.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine" error from the webservice. But I did not get any error from the client application which calls the web service. 

To just explain the functionality a bit, when the user selects a excel spreadsheet in the webpage and submits the file the code behind uploads the file to the server, opens it and verifies the column names and provides a preview of how the data will be processed for the user using the first data row. If any errors are found then it would throw an error. If the preview is good and the columns are good, then when the user hits the confirm button it calls the webservice to process the data in the file. 

I don't understand how I'm getting the "System.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine" error from the webservice and not from the code behind of the web page even though both of them are in the sam machine.

I'm sorry if I'm asking a trivial question. I have been working on ASP .NET only for a short while.

解决方案

Is the web service running as a 64-bit process? This will be a problem since there currently is no support for a 64-bit Jet OLEDB provider.

 

这篇关于System.InvalidOperationException：'Microsoft.Jet.OLEDB.4.0'提供程序未在本地计算机上注册的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！