“Microsoft.Jet.OLEDB.4.0”提供程序未在本地计算机上注册(The 'Microsoft.Jet.OLEDB.4.0' provider is not regi

“Microsoft.Jet.OLEDB.4.0”提供程序未在本地计算机上注册(The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine)

我想在asp.net网站上传一个excel文件，并将这些字段处理成数据集以便进一步操作。 但我收到上面的消息。

我尝试过其他异常选项 - 将列出这些

ex.message - “Microsoft.Jet.OLEDB.4.0”提供程序未在本地计算机上注册。

ex.Source - App_Web_-we0qvgj

ex.StackTrace -

在c：\ inetpub \ wwwroot \ CATALYST_SECONDARY \ Pages \ frmStudentExcelRegistration.btnExcelUpload_Click（对象发件人，EventArgs e）中的第449行：frmStudentExcelRegistration.ExcelToDataset（String FileName） \ frmStudentExcelRegistration.aspx.cs：488行

ex.TargetSite - System.Data.DataSet ExcelToDataset（System.String）

操作系统是windows server 2008。

我浏览了一些论坛，并告诉他们在IIS管理器中更改应用程序池默认设置以允许32位应用程序。 这样做后我收到错误信息 -

“视图状态MAC验证失败，如果此应用程序由Web Farm或群集托管，请确保配置指定相同的验证密钥和验证算法，AutoGenerate不能在群集中使用。

任何人都可以帮助...？

I am trying to upload a excel file in a asp.net website and process the fields into dataset for further operation . but i am getting a message as above .

i have tried with other options of exception - will list those

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

ex.Source - App_Web_-we0qvgj

ex.StackTrace -

at frmStudentExcelRegistration.ExcelToDataset(String FileName) in c:\inetpub\wwwroot\CATALYST_SECONDARY\Pages\frmStudentExcelRegistration.aspx.cs:line 449 at frmStudentExcelRegistration.btnExcelUpload_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\CATALYST_SECONDARY\Pages\frmStudentExcelRegistration.aspx.cs:line 488

ex.TargetSite - System.Data.DataSet ExcelToDataset(System.String)

operating system is windows server 2008 .

I went through some of the forums and they told to change the application pool default setting in IIS Manager to allow 32 bit applications . after doing so I am getting the error message as -

"Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster. "

can anyone help ...?

最满意答案

JET引擎默认安装 - 但是，它只有32位。 当您以64位模式运行应用程序时，会出现问题。 我对桌面应用程序有同样的问题。

在创建ASP.NET应用程序时，更改应用程序池是正确的方法。 正如sehe所说，ViewState消息与此无关。

The JET engine is installed by default - however, it is 32-bit only. The problem arises when you're running an application in 64-bit mode. I've had the same problem for Desktop applications.

As you're creating an ASP.NET application, changing the app pool is the correct way. As sehe said, the ViewState message is unrelated to this.