Skip to content

Knowledge Base

White Paper Libary

Locked solutions ODBC Memory works at runtime but shows error at design time

ODBC Memory events in a task that have been exported from the original task creation machine are functioning correctly at runtime however, at design time an error is displayed.

Connection to database failed

This article provides details about the issue and how it can be resolved:


This issue is caused by the export from the original task creation machine where the relevant ODBC connection has Use Schemas set to Yes and then imported on to a machine with Use Schema set to No.


To resolve this issue, the Use Schemas setting difference with the ODBC memory solution needs to match the setting in the Database Query (ODBC) tool connection.

To apply changes to the Use Schemas setting:

  1. In the resources tree — expand System > Tools > Data Connectors (or Input) and double-click Database Query (ODBC) in the items list. The ODBC Connections panel is displayed.
    ODBC Connections
  2. In the ODBC Connections panel select the required connection and click Properties.
  3. In the displayed connection panel, select the SQL tab.
    Connection to SQL Server
  4. Locate the Use Schemas property, in the Value field select ‘Yes’.
  5. Click OK to save the ODBC connection settings.