Return
-
Title
Error, "Unable to execute linked query. Excel returned the message: "General ODBC Error" Error co -
Description
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. -
Cause
Using an older or incompatible ODBC driver.
-
Resolution
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.
-
Defect ID
ST103361 -
Additional Information
If using a full 10g or 11g Oracle client install, this will include an ODBC driver that can be selected from the properties.