Error, "[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to '<DNS_Name>' failed", (4228562)

When creating a heterogeneous query in the Query Builder between an MS ODBC Oracle Driver and any other database (SQL Server, Excel, etc.) the following error occurs when running the query:

[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'XXXXX' failed.

NOTE: Where XXXXX = DNS Name that was created.

The error does not occur in Toad for Data Analysts 2.0.

WORKAROUND:

Downgrade to Toad for Data Analysts 2.0. The download section of SupportLink can be found at the following:

https://support.quest.com/SUPPORT/index?page=downloads


STATUS:

Waiting for fix to be released in a future version of Toad for Data Analysts.