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
- Phase 1: Start the ODBC Data Source Administrator (32-bit)
-
- Click
Start > All Programs > Micro Focus Enterprise Developer > Enterprise Developer for Eclipse > Data Tools > Data Connections > ODBC Data Source Administrator (32-bit).
Note: On Windows 8, you can also go to the
Start screen and click the
ODBC Data Source Administrator (32-bit) tile.
- Phase 2: Catalog the OESQLDemo Connection
- In this phase, we catalog a 32-bit connection to our SQL Server database.
- From the ODBC Data Source Administrator, click the
System DSN tab; then click
Add.
- From the list of drivers, select the most recently installed version of
SQL Server Native Client; then click
Finish.
- In the
Name field, type
OESQLDemo. This is the name of the ODBC connection.
- 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.
- On the Authenticity dialog box, click
Next to use Windows authentication.
- Change the default database to
OESQLDemo; then click
Next.
- Click
Finish to save your changes.
- Click
Test Data Source to ensure that the connection works properly.
- Click
OK to clear the message.
- Click
OK twice to exit the ODBC Data Source Administrator.
- Phase 3: Refresh the Database Connection
- For OpenESQL Assistant to recognize the connection you have cataloged, you must refresh the connection list in the OpenESQL Assistant.
- In the OpenESQL Assistant, click
Refresh list of data sources
.
This completes the tutorial. Next, please complete
Tutorial: Build and Test a Query.
