Error, "[Microsoft][ODBC Paradox Driver] Syntax error in FROM clause", when creating a Heterog (4236515)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error, "[Microsoft][ODBC Paradox Driver] Syntax error in FROM clause", when creating a Heterog
Description

I'm connecting to a Sybase database via the native client and to a Paradox database via ODBC with a version 4.0 ODBC driver. When I attempt to create a Heterogeneous Query between the two databases, I receive the following error when running the query generated by Toad:
[Microsoft][ODBC Paradox Driver] Syntax error in FROM clause
Cause

Paradox database has not been tested.
Resolution

WORKAROUND:
None.
STATUS:
Waiting for fix to be released in a future version of Toad for Data Analysts.
Defect ID

ST82490

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title