Error when trying to perform a Cross Connection Query between Oracle and another database platform.
Message: Cross Query Database Error: Got error 4206 'Invalid data source definition: ORA-01017: invalid username/password; logon denied; Invalid connection string attribute;ORA-01017: invalid username/password; logon denied' from HUB 1 0
Making the Oracle connection with Direct method.
Connect to Oracle using TNS method (‘Oracle Client’ tab), instead of the 'Direct' tab. You can see these via right-clicking your saved connection, and then click ‘Properties’ (disconnect all connections first). Please do this on all your saved connections that connect to Oracle databases.
If your Oracle Client software is not set up, please let your IT, Helpdesk or DBA people know, and they should be able to provide you with i.e. installation software and assistance, tnsnames.ora file, etc. (they should be able to provide you the 'tnsnames.ora' file and any other .ora files, if needed, depending on your company’s setup).
After connecting using the ‘Oracle Client’ tab (TNS) method, re-test the issue.
