ODBC Data Sources For Microsoft SQL Server

The previous section described the creation of database links within the Application Server. As previously noted, each database link requires an ODBC data source to connect to the database. In this section, we will discuss the steps required for creating a new ODBC data source for use with an Application Server database link.

Creating an ODBC data source for Microsoft SQL Server

1. While creating (or updating) a database link, click NEW in the Create/Update Database Link dialog. A warning dialog will appear, instructing you to create a new system data source.

2. Click OK. A Create New Data Source wizard will appear, allowing you to create a new data source for use with Microsoft SQL Server.

3. Select the System Data Source radio button and click NEXT. This indicates you are going to create a system data source specific to the computer you are currently using.

4. Select “SQL Server” as the driver for the new data source and click NEXT. This tells the setup wizard you want to create a data source for the Microsoft SQL Server database engine.

5. Click FINISH to create the new data source for Microsoft SQL Server. An ODBC SQL Server Setup dialog box will appear, allowing you specify the configuration of the data source you just created (by supplying the data source name, server name, etc.).

6. Type the data source name, description (optional), and the name of the SQL Server where the database resides and click NEXT.

7. Select the “With SQL Server authentication” authentication method and type the appropriate Login ID and Password for connecting to SQL Server. Optionally, you may also click Client Configuration to confirm the data source will be using a TCP/IP connection to SQL Server. When finished, click NEXT.

8. Click the “Change default database” check box, select the appropriate Virtual Ticket/Job Manager database name from the pulldown menu and click NEXT. If you are unsure of the database name, please consult your Database Administrator.

9. Click FINISH to review the new data source settings. If the settings are correct, click TEST DATA SOURCE to confirm that the new data source is configured properly.

10. If the test was successful, click OK to return to the data source settings, then click OK again to add the new data source.