I am receiving this error when attempting to utilize an Oracle database in a cross-connection query. The database connection is set to use the Oracle client and it works fine for a traditional query builder. Any suggestions for how to troubleshoot this issue?
I have tried the suggestion posted elsewhere in this forum to utilize a generic ODBC connection as a workaround, but this results in the same error for me.
What version of TDP are you using. It sounds like an issue we had before where we cached some connection info and then user changed password. Can you update to latest version of TDP and retry? Latest version is 5.0.4