Follow-On Topics

Related Topics

# Adding an OLEDB Connection

Before adding the Database Query (OLEDB) or Call Stored Procedure (OLEDB) tool to a task, connections to OLEDB data sources must be configured. Once configured, all connections can be used by any Database Query (OLEDB) or Call Stored Procedure (OLEDB) step. You open the OLEDB Connections dialog box by either:
|  | Going to Manage > Tools > then either Input, Data Connectors, Output, or Execute and clicking either Call Stored Procedure (OLEDB) or Database Query (OLEDB)
|  | From the , expanding King Task Centre > System > Tools > Data Connectors or Input, and double-clicking either Call Stored Procedure (OLEDB) or Database Query (OLEDB) in the
NOTE: It doesn't matter which tool category you select the Database Query (OLEDB) or Call Stored Procedure (OLEDB) tool from, the same dialog is opened. | Click the image to view full size.

## Choosing an OLEDB Provider

1. Click Add to open the Available OLEDB Providers dialog box, and select a new provider.

   Click the image to view full size.

2. Click OK. The SQL Server Login dialog box opens.

   Click the image to view full size.

3. Enter the database connection settings. If more than one database is hosted on the specified Server, click Options to select the appropriate one for this connection.
4. Click OK to return to the OLEDB Connections dialog box.
5. Click Test to test the connection to the OLEDB data source.
6. Click Close to close the OLEDB Connections dialog box.

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