Part 1: Creating the Data Source in Control Panel
To create a Data Source Name (DSN) that points to a Visual FoxPro database, follow these steps.
NOTE: Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
Click Start, point to Settings, and then click Control Panel.
In Control Panel, double-click the ODBC Data Sources (32bit) icon to start the ODBC Data Source Administrator.
In the ODBC Data Source Administrator, click the User DSN tab, and then click Add.
In the Create New Data Source dialog box, click the Microsoft Visual FoxPro driver, and then click Finish.
In the ODBC Visual FoxPro Setup dialog box, in the Data Source Name box, type a name for your new data source, for example, myFoxpro.
In the Description box, type a description, for example, "Foxpro odbc for InfoCaptor".
Under Database type, click Visual FoxPro database (DBC).
In the Path box, type the path to your .dbc file, or click Browse to locate the file, and then click OK. The data source is created.
Open the connection window as shown below in the link
Replace the odbc name "northwind" with the name for the DSN (for e.g myFoxpro) that you created in Part 1.