SQL Server与VFP数据库的连接实现

The Realization of Linking VFP Database with SQL Server

VFP用于开发一些中小型的管理系统,但是它的数据管理功能不是很强,所以很多人用专业关系数据库管理软件SQL SERVER对VFP的数据库进行管理,而且SQL这种基于客户机/服务器(Client/Server)体系结构的数据库系统应用越来越广泛。使用SQL与VFP两种不同的软件联合进行项目开发,就涉及到了如何进行连接的问题,本文给出了两种连接方式:一种是通过ODBC实现数据库的互连;另一种是程序中动态连接的方式。希望对大家的学习和工作有一些帮助。

VFP is used to develop some small administration system, but because its data administration function is not very strong, many users make use of SQL SERVER to administrate VFP database. And more and more fields use the SQL data-base based on client and server. To use SQL and VFP to develop some subjects is involved in how to combine the two soft-wares. This article providees two combining methods： one is the ODBC, and the other is the method of a movable combining program in hopes of being helpful to the readers.