Tutorial: Catalog a Connection

Before you can connect to the SQL Server database you created earlier, you must catalog it using the ODBC Data Source Administrator (32-bit).

Requirements

Before attempting this tutorial, you must complete the following tutorials in the order listed:

• Tutorial: Create a SQL Server Database
• Tutorial: Create and Configure an Eclipse Project
• Tutorial: Set OpenESQL Assistant Configuration Options

Start ODBC Data Sources 32-bit Administrative Tool

This is a Windows operating system Administrative tool. It's location on the Start menu varies from one version of Windows to another. We suggest that you find and launch the ODBC Data Sources (32-bit) tool using the search box provided by the Start menu. Search for ODBC to find the tool.

Catalog the OESQLDemo Connection

Using the ODBC Data Source Administrator, you catalog a 32-bit connection to your SQL Server database.

1. From the ODBC Data Source Administrator, click the System DSN tab; then click Add.
2. From the list of drivers, select the most recently installed version of SQL Server Native Client; then click Finish.
3. In the Name field, type OESQLDemo. This is the name of the ODBC connection.
4. From the drop-down list, select a SQL Server, or type the name of a server such as (local) or (localdb\v11.0), depending on what SQL Server product you have installed; then click Next.
5. On the resulting dialog box, click Next to use Windows authentication.
6. Change the default database to OESQLDemo; then click Next.
7. Click Finish to save your changes.
8. Click Test Data Source to ensure that the connection works properly.
9. Click OK to clear the message.
10. Click OK twice to exit the ODBC Data Source Administrator.

This completes the tutorial. Next, please complete Tutorial: Build and Test a Query.