I am using TDP v126.96.36.19994
I cannot create a cross-connection query between an Exel file and an Oracle table. I get the ‘Cross Query Database Error’ ‘Invalid data source definition: Data source name not found and no default driver specified’
Here is what’s odd. Query Builder is creating the query.
Here are my steps.
- I open both data sources: Excel and Oracle.
- I drag the spreadsheet and the Oracle table into Query Builder.
- I select my fields and join the tables.
- When I run the query I get the error.
Why is Query Builder creating an invalid query?