替换DAO数据库类 [英] Replacing DAO Database classes

问题描述

嗨！

我正在将旧项目从32位环境迁移到64位环境.
到目前为止，这并不是什么大问题，但是我有一个用于与Access DB一起使用的模块.如您所知，Win64不支持DAO数据库类，据我从Google搜索得知，它们已被弃用.

目前无法用SQL Server CE或SQLite DB替换Access DB(管理如此说)，因此我必须编写新的代码段才能在Win64上运行(编译)，并且从何处开始面临困境.
我正在考虑使用一些现有的库，因为这将是最省时的工作，还是应该使用OLEDB或CDatabase重写特定的代码(用MFC完成了大量程序)?

您可以向我推荐这样的库或解决此问题的正确方法吗?

偶尔作为C ++程序员也无济于事. =/



P.S.
我刚刚发现无法使用Jet连接到64位OS上的.mdb文件，相反，我应该为Access 2010使用新的ACE驱动程序.

Hi!

I am in the process of migrating legacy project from 32bit to 64bit environment.
So far it wasn''t much of issue, but I have one module which is used for working with Access DB. As you probably know DAO Database classes are not supported for Win64 and as far as I can tell from my Google searches they are deprecated.

At the moment replacing Access DB with SQL Server CE or SQLite DB is out of the question (management says so), therefore I have to write a new piece(s) of code which will work(compile) on Win64 and I''m having a dilemma where to start.
I am thinking about using some existing library as it will be the least time consuming endeavor or should I rewrite particular code using OLEDB or CDatabase (great deal of program has been done with MFC)?

Can you recommend me such library or correct approach to solve this problem?

Being occasional C++ programmer doesn''t help either. =/



P.S.
I''ve just found out there is no way to connect to .mdb file on 64bit OS with Jet, instead I should use new ACE drivers for Access 2010. It seams pretty straight forward.
Is there anything else I should consider?

推荐答案

在安装应用的每个系统上，您都需要Microsoft Office 2010的许可副本.

如果这是内部应用程序，则可能不是问题.

如果它是交付给客户的应用程序，则这可能会增加产品的大量许可和支持成本.

You''ll need a licensed copy of Microsoft Office 2010 on every system you install your app on.

If it''s an in house application that may not be a problem.

If it''s an application that is shipped to customers, then this could add significant licensing and support costs to your product.

这篇关于替换DAO数据库类的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！