The method of SQL Server connecting VFP database

The interconnection of different database platform is commonly called the heterogeneous service of the database, now each big database can realize such heterogeneous interconnection, but the specific implementation technology of each vendor is not the same, such as: In SQL Server called linked server, through ODBC and other database interconnection.

The test environment for this article is:

Operating system: WINDOWS2000 SERVER (Traditional system)

Installation database: SQLSERVER2000 (English) and VFP6.0

Specific steps to achieve:

1. require PC to install VFP6.0 and SQL Server2000 software.

2. Configure Windows ODBC data source.

Start Menu-"assembly-" System management Tool-"data source (ODBC)-" Enter configure User DSN or System DSN can: Add-"Select Microsoft FOXPRO VFP DRIVER (*. DBF)-In the ODBC VISUAL FOXPRO Setup screen, customize the data source name (optional: vfptest)-The database type can select VISUAL FOXPRO databse (*. DBC) or free TABLE DIRECTORY (*. DBF such as Select this can be a free choice of directory)-"OK complete."

Configure and test ODBC complete!

3. Configure the connection server in sqlserver2000

Enterprise Manager-"Security-" Connection server-"right" New connection server-"define the connection name;" Select a different data source; Specifies that the program name is: MICROSOFT OLE DB PROVIDER for ODBC DRIVER; Product name is not filled; The data source specifies the name of the data source that is defined in ODBC just now; The provider string is filled in the following format: User id=username; PASSWORD=USERPASSWD (or in the following format: Uid=username; PWD=USERPASSWD), where the username and password corresponding to the VFP database to be connected to the user name and password-"Security tab: Set up in this security context, and input VFP database username and password-" Server Option tab page can default-"OK."

4. All preparations are complete!

In SQL Server Enterprise Manager-"security-" connect the server to open the newly built connection server-"Click on the table, you can see in the right window of the VFP database users have all the table names, but here also can not view the records of the table, This needs to be implemented in the Sqserver Query Analyzer with specific SQL! When accessing a table, use the format: [Connect server name]. [VFP users]. [Table name]. More detailed and specific use here no longer repeat.