Microsoft Access数据库引擎2010可再发行 [英] Microsoft Access Database Engine 2010 Redistributable

问题描述

大家好

我们有一个Web应用程序，其中客户端必须将数据上传到excel文件中.我们正在使用"Microsoft.ACE.OLEDB.12.0"提供程序读取excel文件，该提供程序需要安装 Microsoft Access数据库引擎2010可再发行版 .该应用程序在开发环境中运行良好.

当我由于某种安全问题而将应用程序表单开发人员移至正式生产阶段时，不允许他们安装 Microsoft Access Database Engine 2010可再发行组件.其原因仅是

Access Database Engine 2010 Redistributable不适用:

由系统服务或服务器端程序使用，其中代码将在系统帐户下运行，或者将同时处理多个用户身份，或者高度可重入并期望无状态行为.示例包括当没有用户登录时从任务计划程序运行的程序，或从服务器端Web应用程序(如ASP.NET)调用的程序，或在COM +服务下运行的分布式组件.
任何人都可以向我解释以上原因的含义或给出一些替代方案.

解决方案

忘记访问权限，这并不严重.使用其他基于客户端-服务器模型的RDBMS.有一些可供选择:
http://en.wikipedia.org/wiki/Comparison_of_databases [ http://博客. msdn.com/b/farukcelik/archive/2010/06/04/accessing-excel-files-on-a-x64-machine.aspx [Microsoft Access Database Engine 2010 Redistributable .The application is running fine in dev env.

when i move the application form dev to porduction due to some security issue they are not allowd to install Microsoft Access Database Engine 2010 Redistributable .the reason for that only is

The Access Database Engine 2010 Redistributable is not intended:

To be used by a system service or server-side program where the code will run under a system account, or will deal with multiple users identities concurrently, or is highly reentrant and expects stateless behavior. Examples would include a program that is run from task scheduler when no user is logged in, or a program called from server-side web application such as ASP.NET, or a distributed component running under COM+ services.

can anyone explain me the meaning of above reason or give some alernatives.

解决方案

Forget Access, this is just not serious. Use some other RDBMS based on client-server model. There are some to choose from:
http://en.wikipedia.org/wiki/Comparison_of_databases[^].

—SA

I think the below link will help you.

http://blogs.msdn.com/b/farukcelik/archive/2010/06/04/accessing-excel-files-on-a-x64-machine.aspx[^]

这篇关于Microsoft Access数据库引擎2010可再发行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！