SQL Server Connect to the implementation of the VFP database
Author: CCBZZP interconnection of different database platforms generally called heterogeneous database services, can now achieve such heterogeneous interconnect between all major databases, but the manufacturers not the same as the specific implementation technology, such as: in SQL SERVER It is called Linked Server, and Internet interconnection with other databases is implemented via ODBC.
The test environment of this article is:
Operating system: Windows2000 Server (Traditional System)
Installing Database: SQLServer2000 (English) and VFP6.0 Specific steps: 1. Requires installation of VFP6.0 and SQLServer2000 software on your PC. 2. Configure Windows ODBC Data Source: Start Menu - "Program -" System Management Tool - "Data Source (ODBC) -" Enter User DSN or System DSN can: Add - "Select Microsoft FoxPro VFP Driver (* .Dbf) - "In the ODBC Visual FoxPro Setup screen, custom data source name (free such as: vfptest) -" Database Type can select Visual FoxPro Database (*. DBC) or Free Table Directory (*. Dbf, if you choose this Free selection directory) - "OK is done.
Configure and test ODBC!
3. Configure the connection server in SQLServer2000: Enterprise Manager - "Security -" Connection Server - "Right-click New Connection Server -" Define Connection Name; Select another data source; specify the program name: Microsoft Ole DB Provider for ODBC Driver; The product name can not be filled; the data source specifies the data source name that is just defined in the odbc; the provider string is filled in in the following format: user ID = username; password = userpasswd (or press UID = UserName; PWD = Userpasswd), The username and password here correspond to the username and password in the VFP database you want to connect - "Security tab: Settings with this security context, and enter the VFP database username and password -" Server option tab can be default - "OK . 4. Preparations are all completed! In SQL Server Enterprise Manager - "Security -" Connection Server Opens the Junited Connection Server - "Click on the table, you can see all the table names owned by the VFP database user in the right window, but you can't view it here. Record of the table, this need to be implemented in specific SQL in the query analyzer of SQ Server! When accessing the table, the format is: [Connect Server Name] .. [VFP User]. [Type]. More detailed use is not described here.
In the future, add it!
