Toad World® Forums

Oracle External Authentication and Join Analysis

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?

tdp-advanced-tab.jpeg

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.