With the previous versions of FoxPro, there was not a way to select an ODBC
File DSN, visually, from the Connection Designer. The steps below
illustrate how you can select an ODBC File DSN from the Visual FoxPro
Connection Designer:
- Use the ODBC Manager to create a "File DSN" Data Source.
- Run Visual FoxPro and open a database.
- From the File menu, select New. In the New dialog box, select Connection
and then choose New File. This opens the Connection Designer.
- In the Connection Designer, under the "Specify Data Source" section,
select the Connection string option button.
- Blank out the contents of the Connect string.
- Select the "Verify Connection..." button or click the ellipses (...)
button to the right of the Connectstring text box. This opens the
"Select Data Source" ODBC dialog box. The ODBC dialog box has the
following two tabs:
File Data Source (File DSN's)
Machine Data Source (System DSN's)
- Select a File DSN from the "File Data Source" tab.
- After you select the OK button, a dialog may appear asking for login
information or a message may appear stating the connection succeeded.
- The Connection string from the File DSN is entered into the Connect
string of the Connection Designer.
- Save the connection and close the Connection Designer.