Windows Server 2016中的Access数据库引擎OLEDB [英] Access Database engine OLEDB in windows server 2016

问题描述

我有一个使用Microsoft ACE OLEDB 12.0驱动程序的应用程序，因此我在系统中安装了2007 Office System驱动程序:数据连接组件.

I have an application that uses Microsoft ACE OLEDB 12.0 driver and hence I have installed 2007 Office System Driver: Data Connectivity Components in my system.

我还创建了SSIS包，以使用Microsoft ACE OLEDB 12.0从excel和csv文件中提取数据，这些数据已插入到SQL表中.下面是我的连接字符串

I also have created SSIS packages to pull data from the excel and csv files which get's inserted into the SQL tables using the Microsoft ACE OLEDB 12.0. Below is my connection string

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myOldExcelFile.xls;
Extended Properties="Excel 8.0;HDR=YES";

我想将这些应用程序移到服务器环境中进行部署，当我向IT部门寻求安装Office 2007系统驱动程序的请求时，他们表示Windows Server 2016不支持该驱动程序，并且存在安全漏洞.

I wanted to move these applications to the server environment for deployment and When I reached out to the IT for getting Office 2007 system driver to be installed, they said it's not supported in Windows server 2016 and have security vulnerabilities.

因此，我想知道我们是否还有其他Microsoft OLEDB提供程序用于SSIS操作?我尝试安装Office 2010，但收到错误消息

Hence I wanted to know whether we have any alternate Microsoft OLEDB provider for SSIS operation? I tried installing office 2010 however I got the error message that

Microsoft OLEDB 12.0未在我的计算机上注册.

Microsoft OLEDB 12.0 is not registered on my machine.

将安装Microsoft Access Database Engine 2016 Redistributable将帮助我解决问题.如果是，我的连接字符串是什么.以下一项正确吗?

Will installing Microsoft Access Database Engine 2016 Redistributable help me out in resolving the problem. If yes what will be my connection string. Is the below one correct?

Provider=Microsoft.ACE.OLEDB.16.0;Data Source=c:\myFolder\myOldExcelFile.xls;Extended Properties="Excel 12.0;HDR=YES";

Windows Server 2016也不支持Office 2016 oledb.因此，当我们在Windows Server 2016上安装Office 2007或2016时，会发生哪些安全漏洞?

The office 2016 oledb is also not supported in windows server 2016. Hence what security vulnerabilities will occur when we install Office 2007 or 2016 on windows server 2016?

任何帮助都会得到高度赞赏.

Any help will be highly appreeciated.

推荐答案

我的计算机上未注册Microsoft OLEDB 12.0.

Microsoft OLEDB 12.0 is not registered on my machine.

由于安装了Access Database Engine 2010，并且收到上述错误，因此看来这是一个32/64位问题.

Since you installed Access Database Engine 2010 and you received the error above, then it looks like it is a 32/64 bit problem.

确保同时安装了可再发行版32和64.

Make sure you installed both redistributables 32 and 64.

如果需要与32位安装一起安装AccessDataBaseEngine x64，则需要以被动模式运行安装:

If you need to install AccessDataBaseEngine x64 alongside with 32-bit installation, you need to run the installation in passive mode:

被动模式安装步骤

1. 通过在开始"菜单下的Windows搜索框中键入cmd并选择cmd.exe来打开命令提示符
2. 键入64位Access Database Engine 2010安装文件的文件路径和文件名，后跟一个空格和/passive(这将运行安装而不显示任何错误消息).
3. 通过在开始"菜单下的Windows搜索框中键入regedit并选择regedit.exe
，打开注册表编辑器.

4. 在以下注册表项中删除或重命名mso.dll注册表值:

1. Open the Command Prompt by typing cmd in the Windows search box under the Start menu and selecting cmd.exe
2. Type the file path and file name of the 64-bit Access Database Engine 2010 install file, followed by a space and /passive (this runs the installation without showing any error messages).
3. Open the Registry Editor by typing regedit in the Windows search box under the Start menu and selecting regedit.exe

4. Delete or rename the mso.dll registry value in the following registry key:

"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths" 

更多详细信息和屏幕截图，请参见下面的链接

参考

• 查看全文