Toad World® Forums

Cross-Connection error - JOIN from Oracle to Teradata

Attempting a cross-connection query in Toad Data Point Pro 3.6, with an outer join from Oracle to Teradata, and getting this error:

ODBC data source returned an error: No DBCName entries were found in DSN/connection-string

Then clicking on the Explain Plan tab crashes TDP with message: “Toad encountered a serious error and must close”. The connections to both Oracle and Teradata are working, I can query each separately in Cross-Connection Query Builder, the error happens when I attempt to run a query with a join between Oracle and Teradata.

You will need to open a support ticket for that one so we can get all the info and schedule a fix.