Will the master door, how to connect with VFP6.0 SQL database, and access to data
Users questions:
Experts answer: first establish a database, create a remote view in the database, the remote view is the application of standard ODBC, to achieve heterogeneous database connection, you can access and update data. Database connections there, this is also the ODBC connection, if the first set up ODBC connection, you canTo repeat the reference to the connection, to facilitate the establishment of multiple remote view, .1. First need to [Control Panel] - [Administrative Tools] and enter the [Data Source ODBC] - [user DNS], check whether there SQLServer Data Source .2. If there is no SQL option. In thisWhere you need to add SQLServer driver 3. Add drive when the data source name (such as SQLServer), and would you want to connect to the database name, login database user name password set up. And then in VFP, 1. New Remote View 2. Select the data source (Or select a good connection has been established) SQLServer.3. In the list, select the table to link it to do. Follow the prompts, not complicated.