Follow-On Topics

Related Topics

# About the Available Sources Dialog

The Available Sources dialog box is displayed when the Add button is selected in the Connections tab of the Global Configuration dialog box for the Database Query (ODBC) tool. The SQL Server Browser service is disabled by default in some versions of SQL Server. This service must be running in order to see a SQL Server in the list of available servers for selection. You should contact your System Administrator if your SQL Server service settings need amending.

NOTE:

Certain editions of the software may display a product specific dialog box. Please contact your System Administrator for more information.

The dialog box is used to select the ODBC Driver or existing Data Source definition for the connection.

ODBC Drivers

Expanding the ODBC Drivers branch displays a list of ODBC Drivers available on the client machine.

NOTE:

It is important to ensure that the driver selected is also available on the server host machine for Tasks using this Connection to work.

Selecting an ODBC Driver and then pressing the OK button displays the ODBC Driver configuration dialog box box. For example, if SQL Server is selected then the Microsoft SQL Server ODBC Driver configuration dialog box box is displayed.

Data Sources

Expanding the Data Sources branch displays a list of Data Sources available on the client machine.

NOTE:

It is important that a Data Source of the same name exists on the server host machine for Tasks using this Connection to work.

When selecting a Data Source and then pressing the OK button, an attempt is made to connect to the Data Source and if successful will continue to allow the Connection to be named. If unsuccessful, the driver may prompt for further information.

File Data Sources

Expanding the File Data Sources branch displays a list of available File Data Sources.

NOTE:

The File Data Source selected must be available from the server host machine for Tasks using this Connection to work. Use UNC paths wherever possible to make the connection available from the server host machine and all clients.

When selecting a File Data Source and then pressing the OK button, an attempt is made to connect to the Data Source and if successful will continue to allow the Connection to be named. If unsuccessful, the driver may prompt for further information.

## ODBC Data Sources

New Data Sources may be created using the Microsoft ODBC Data Source Administrator which is accessed through:

Control Panel > Administrative Tools > Data Sources (ODBC) > File DSN Tab > Add button.

Copyright © 2018 Quadrant Software B.V. All rights reserved.