ODBC Excel驱动程序:来自外部数据库驱动程序的意外错误 [英] ODBC Excel Driver: Unexpected error from external database driver

问题描述

自Windows更新于10月10日以来，ODBC Excel驱动程序已停止工作.尝试读取文件时出现以下错误:

Since the Windows update from October 10, the ODBC Excel drivers have stopped working. We get the following error when trying to read a file:

来自外部数据库驱动程序的意外错误(1)"

"Unexpected error from external database driver (1)"

我们使用带有以下连接字符串的ADO连接在Delphi中打开Excel文件:

We open Excel files in Delphi using an ADO connection with the following connection string:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

我可以通过切换到Microsoft.ACE.OLEDB.12.0使其工作，但要使其正常工作，我们所有的客户都必须在使用我们的软件的所有计算机上安装Microsoft Access Database Engine Redistributable.

I can get it to work by switching to Microsoft.ACE.OLEDB.12.0, but for that to work, all our customers would have to install the Microsoft Access Database Engine Redistributable on all the computers they use our software on.

有人有其他解决方案或解决方法吗?预先感谢.

Does anybody have another solution or workaround? Thanks in advance.

推荐答案

在客户计算机上，我卸载了最后一个Microsoft补丁随附的KB4041681(Windows 7). 在我的计算机上，我已经卸载了KB4041676(Windows 10). 之后，Microsoft.Jet.OLEDB.4.0现在可以工作了.

On a customers machine I have deinstalled KB4041681 (Windows 7) which came with last Microsoft Patch. On my machine I have deinstalled KB4041676 (Windows 10). After that Microsoft.Jet.OLEDB.4.0 is now working.

我希望微软会尽快修复此错误.

I hope that Microsoft will fix this bug soon.

这篇关于ODBC Excel驱动程序:来自外部数据库驱动程序的意外错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！