且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

64 位模式不支持 OleDB?

更新时间:2022-12-28 23:17:35

这里讨论要做什么 关于不推荐使用的 MDAC.恐怕答案不是很令人满意...

Here is a discussion of what to do about deprecated MDAC. I am afraid the answer is not very satisfying ...

这些新的或改装的 Jet应用程序可以继续使用 Jet有意使用微软Office 2003 和更早版本的文件 (.mdb和 .xls) 用于非主要数据贮存.然而,对于这些应用程序,您应该计划从 Jet 迁移到 2007 Office系统驱动程序.你可以下载2007 Office 系统驱动程序,其中允许您读取和写入任一 Office 中预先存在的文件2003(.mdb 和 .xls)或 Office2007(*.accdb、*.xlsm、*.xlsx 和*.xlsb) 文件格式.重要请阅读 2007 Office System 最终用户特定用途的许可协议限制.

These new or converted Jet applications can continue to use Jet with the intention of using Microsoft Office 2003 and earlier files (.mdb and .xls) for non-primary data storage. However, for these applications, you should plan to migrate from Jet to the 2007 Office System Driver. You can download the 2007 Office System Driver, which allows you to read from and write to pre-existing files in either Office 2003 (.mdb and .xls) or the Office 2007 (*.accdb, *.xlsm, *.xlsx and *.xlsb) file formats. IMPORTANT Please read the 2007 Office System End User License Agreement for specific usage limitations.

注意:SQL Server 应用程序也可以访问 2007 Office System,以及之前,来自 SQL Server 的文件异构数据连接和集成服务功能作为好吧,通过 2007 Office System司机.此外,64 位 SQL服务器应用程序可以访问32 位 Jet 和 2007 办公系统使用 32 位 SQL Server 的文件64 位集成服务 (SSIS)窗户.

Note: SQL Server applications can also access the 2007 Office System, and earlier, files from SQL Server heterogeneous data connectivity and Integrations Services capabilities as well, via the 2007 Office System Driver. Additionally, 64-bit SQL Server applications can access to 32-bit Jet and 2007 Office System files by using 32-bit SQL Server Integration Services (SSIS) on 64-bit Windows.