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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center