Database connection problem with Toad :(

Hi all,

I connect to our databases fine with tnsping and sqlplus - but Toad consistently gives ora12154 when I try to connect. I get my tnsnames from tnsadmin environment variable pointing to a network location. I know that loads fine because Toad gives me all of the database options, and they work just fine in sqlplus (where I can really connect).

I’m running win 7 64 bit, and using Toad 10.6.0.42, with oracle client 10…2.0.

Any insight on why Toad doesn’t seem to want to connect, but everything else is fine?

Thanks for tips,
-sff

If you are not using a 32 bit Oracle client, you need to install one. Toad
can’t use the 64 bit Oracle client.

Thanks for the reply.

How do I tell which one I have? (Machine just came imaged from the helpdesk and I’m more a mssql guy :slight_smile: )

Hmm…that’s a good question! Other than where you download it from,
I’m not sure.

Click the little “…” button next to the “connect
using” dropdown on Toad’s login screen. If it says “home is
valid”, then it’s 32 bit. If there is some other problem, it should
tell you. If there are multiple in there, be sure to pick a valid one.

Turns out my oracle client was ok, it’s just that toad was installed to a directory whose name contains parenthesis. Apparently that just makes things all go wonky for toad (shrug). Resolution was easy: just uninstall and reinstall to a paren-free folder. Silly, but it works now. yay!

had the same problem where someone decided to use whitespace characters to name
their input folder something like
Aunt Susan’s (secret) tax records

i decided to create a folder called AuntSusan …tossed everything in there and
the client software gratefully accepted the input folder of ‘AuntSusan’

i regret the day Apple and Microsoft allowed whitespace characters in their
folder names

oi vay
Martin


Jogi és Bizalmassági kinyilatkoztatás/Verzicht und
Vertraulichkeitanmerkung/Note de déni et de confidentialité

Ez az üzenet bizalmas. Ha nem ön az akinek szánva volt, akkor kérjük, hogy
jelentse azt nekünk vissza. Semmiféle továbbítása vagy másolatának
készítése nem megengedett. Ez az üzenet csak ismeret cserét szolgál és
semmiféle jogi alkalmazhatósága sincs. Mivel az electronikus üzenetek
könnyen megváltoztathatóak, ezért minket semmi felelöség nem terhelhet
ezen üzenet tartalma miatt.

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung
fuer den Inhalt uebernehmen.

Ce message est confidentiel et peut être privilégié. Si vous n’êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l’expéditeur. N’importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l’information seulement et n’aura pas n’importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.

Not a toad bug per se – a bug with sql net client (documented on
metalink). You’ll find this point brought up about 5-6 times a year on the
toad community – it’s a common problem when using older oracle
clients that don’t support 64 bit OS. In fact if you look on metalink
you’ll see that few versions support Windows 7 (i.e. 10g came out before
Win 7 – so not officially supported).

Hi...I haven't seen where to change that in Toad so I've change that values directly in my SQL Server making it accept Local and Remote connections using both TCP/IP and Named Pipes Protocols.Let me know if you know how to change this values in Toad.

@pansysharp - Are you using Toad for Oracle or Toad for SQL Server? You are in the Toad for Oracle forum, so if you meant SQL Server, you should start a new thread here: https://forums.toadworld.com/c/toad-for-sql-server/11