I’ve gotten a Heterogeneous Query setup to try and avoid having to build an intermediate Access Database in order to cross-reference data from our Oracle Instance to the User data stored on the SQL Server (they cannot both be stored in one or the other - that’d be too easy).
I keep getting an error message:
“Error:3/23/2010 0:00:00.015: [Microsoft][ODBC Microsoft Access Driver] Unrecognized keyword WHEN.”
Which appears to be an issue with the CASE statement that I’m using in the query. What’s odd about that, and I’m not sure what I have to do to fix it, is that the CASE query should not be executing against the SQL Server - only against Oracle.
Is there something I have to do, to specify which parts of the query execute against which source? This is not a query that was built natively in TDA - the first version was written by hand in SQLTools, I then imported and tweaked it in TDA - all of that was fine until joining to the SQL Server.