"The Microsoft Jet database engine cannot find the input " error with heterogeneous queries an (4234892)

When trying to run a heterogeneous query that uses a Sybase IQ connection, the query errors out.

"Error 3/2/2009 7:39:10 PM 0:00:27.297 [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query <OBJECT>. Make sure it exists and that its name is spelled correctly. 1 0"

But the objects exist, and the query, with only the Sybase IQ connection (non-heterogeneous) works without any problems.

Â

WORKAROUND:
none

STATUS:
Enhancement request ST60060 has been submitted to Development for consideration in a future release of Toad for Data Analysts.