Visual Studio2010中访问VFP表方法研究

摘要

In this article,we have studied and discussed the methods of how to access VFP tables in Visual Studio 2010.The common ways to access the VFP tables are ADO and RDO.The results showed that the ADO access to the VFP tables has some BUG,and will make the program is abnormal.If use the RDO to access the VFP tables,we need to make the VFP ODBC driver vfpodbc.dll,the component file Interop.RDO.dll and the file MSRDO20.dll are pack-aged together,and to make MSRDO20.dll has been registered in windows,as in the software is released.In this article,we have given the registration keys and the registration values for the file MSRDO20.dll,as well as the registration code in the software of Setup Factory 9.%针对在Visual Studio 2010中的VB.NET下如何访问VFP表的方法进行了研究和讨论.常用的访问数据库表的方式有 ADO、RDO 和 OleDb 等.主要讨论了 ADO 和 RDO 两种访问 VFP 表的方式.研究发现 ADO 方式访问VFP表存在一些BUG,会使程序出现异常.使用RDO方式访问VFP表,在软件发布时,需要将 VFP的 ODBC驱动程序vfpodbc.dll、组件文件 Interop.RDO.dll和文件 MSRDO20.dll进行打包,并对MSRDO20.dll进行注册.本文中给出了MSRDO20.dll的注册项和注册值,以及在应用Setup Factory 9建立的软件安装包中所要输入的注册代码.