Connect to an ODBC source: Example
The procedure provides an example of how to connect to an ODBC source (using Windows 7) when connecting individual fields to a specific database table.
Use the following steps as inspiration to connect to an ODBC source on Windows 7:
- Click Start > Control Panel.
- Open Administrative Tools and double-click Data Sources (ODBC).
- On the System DSN tab of the dialog, click Add.
- Select SQL Server, and then click Finish.
- Type an appropriate name and description (if desired) for the data source in the Name and Description boxes respectively. Make a note of the name as you will need it later.
- In the Server box, select the appropriate server from the dropdown list, or type in the server name if it is not in the list. Click Next.
- Select With Windows NT autentication using the network login ID and click Next.
- Select Change the default database to and select the name, specified in step 5, from the dropdown list, and click Next.
- Select Perform translation for character data and click Finish.
- Click Test Data Source to test the connection. You should receive the message, "TESTS COMPLETED SUCCESSFULLY!"
- Click OK twice to return to the System DSN tab of the dialog, and click OK once more to close the dialog.