18 February, 2009

TOAD connection problem under Windows XP x64

I've catch this problem with my installation of TOAD (and with PLSQL Developer) under Windows XP 64-bit edition:
"ORA-12154: TNS:could not resolve the connect identifier specified" (but under Windows XP 32-bit all OK).

And here is the simplest solution:
run TOAD via command line using short path: C:\PROGRA~2\QUESTS~1\TOAD\TOAD.exe
instead of long: C:\Program Files (x86)\Quest Software\TOAD\TOAD.exe

Unfortunately Windows doesn't allow to change desktop's shortcut from long mode to short (Windows always expands short paths).

Or... move TOAD from "Program Files (x86)" to "Program Files" directory.

7 comments:

Anonymous said...

This tip works great. Thanks!

Anonymous said...

thanks! also works on Vista x64

Anonymous said...

Thanks for the tip, works a treat.

Eoghan

Anonymous said...

Thanks! Thanks! Thanks!
:)

Anonymous said...

I was going insane with this error until I found this post. Thank you! It worked like a charm...

Anonymous said...

Excellent!!!

Anonymous said...

We have this problem on new XP 64bit computers. I search websites until I found this web page. Thank you very much for your advice. It works.