Follow-On Topics

Related Topics

# Adding ODBC Connections

To use the Database Query (ODBC) Tool, connections to data sources must first be configured through the ODBC Connections dialog box. A Connection contains all the information necessary to connect to a given database and once this is configured the connection can be used by any user who has permissions.

You open the ODBC Connections dialog box by either:

|  | Going to Manage > Tools > , then either Data Connectors > Database Query (ODBC) or Input > Database Query (ODBC)

|  | From the , expanding King Task Centre > System > Tools > Data Connectors or Input, and double-clicking Database Query (ODBC) in the

## Choosing an ODBC Driver

1. Click Add to open the Available Sources dialog box, and select a new database.
2. Click Properties to open the Properties dialog box, and configure the database connection settings.
3. Click Test to test the connection to the ODBC data source.
4. Click Close to close the ODBC Connections dialog box.

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