I am trying to do a join analysis and generate the venn diagram. I have a 2016 SQL server data base that I have successfully connected to and an Oracle 11.02 database that I have successfully connected with using External authentication. When connecting via external authentication I am not using a username or password in the connection dialog. I have successfully pulled tables from each of the databases into the workspace and would like to join them on a field and use the join analyzer.
when i click on the join to do the analysis, and generate the venn diagram, i get an error message that says can’t connect to my oracle database ORA-01005: null password give; logon denied; so it sounds like it isn’t recognizing the external authentication.
how do i get the analyzer to recognize the database is using external authentication and pass my credentials?
thank you for helping me through my newbie issues!
Have you setup the ODBC connection string under the ADVANCED tab on the connection window?
Thanks for replying. I tried this and still receive the error.
can you open up a support case? We will need more info and try to recreate the issue.
support case opened. SR Number:4029258
thanks
Randy Holmes
Information Technology
Butler Works
email: Randy.Holmes@aksteel.com
phone: 724.284.2396
fax: 724.284.2573
From: Debbie Peabody bounce-Debbie_Peabody@toadworld.com
To: toaddatapoint@toadworld.com
Date: 05/10/2017 09:54 PM
Subject: RE: [Toad Data Point - Discussion Forum] Oracle External Authentication and Join Analysis
RE: Oracle External Authentication and Join Analysis
Reply by Debbie Peabody
can you open up a support case? We will need more info and try to recreate the issue.
To reply, please reply-all to this email.
Stop receiving emails
on this subject.
Or Unsubscribe from Toad Data Point Forum
notifications altogether.
Toad Data Point - Discussion Forum
Flag
this post as spam/abuse.
Confidentiality Notice
This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information.
If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.
That’s wierd. The support case is under Toad for Oracle. Let me see if I can get it changed.