This knowledge base will show how to create an ODBC system DSN for use by an OLEDB call stored procedure. This will allow to call store procedures where an ODBC driver is available.
Creating a new system DSN
- Load 32bit ODBC Data Source Administrator.
- Select the System DSN tab and select Add.
- From the list select an ODBC driver and select Finish.
- Define a unique name and provide the server and port combination for the data source. Provide the login credentials for the connection.
Note: The connection parameter box may appear different depending on what ODBC driver has been selected.
- If the option is available select a database to connect to from the drop down list. Finally select Test.
- Select OK to complete. A new system DSN has now been created, the entry will appear in the System Data Sources list of the ODBC administrator.
Configuring Call Stored Procedure (OLEDB) global configuration
- Within TaskCentre open the Call Stored Procedure (OLEDB) global properties via the following:
Manage -> Tools -> Input -> Call Stored Procedure (OLEDB)
via the TaskCentre system tree
- Click Add to begin creating a new connection.
- From the list select Microsoft OLE DB Provider for ODBC Drivers.
- Select the Machine Data Source tab and from the list locate the previously created DSN and select OK.
- Confirm the database connection details and select Test. A message should appear saying Connection Successful.Note: The fields may already be populated with the correct information from when the DSN was created. If not, complete the fields and select ‘Test’.
- Select OK to close which will prompt for a connection name.
- Provide a unique name for the connection and select OK. The new entry will now be displayed in the connection list.
The connection is now available for the Call Procedure tool to reference stored procedures within databases where only an ODBC connectivity layer is available.