On any query in the Editor and clicking on the Export Linked Query button, a new blank Excel instance window opens and behind it there's a message that says the following:
Unable to execute linked query.
Excel returned the message: "General ODBC Error"
Error code: 800A03EC Export is cancelled.
Using an older or incompatible ODBC driver.
1. Right-click the Oracle Connection and go to Properties.
2. Click on the Advanced tab and in the ODBC Driver section, select something similar to:
Oracle in OraDb11g_home1
3. Save and Connect and re-test.
If using a full 10g or 11g Oracle client install, this will include an ODBC driver that can be selected from the properties.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy