Friday, April 15, 2011

Toad Connection Error on a Windows 64-bit Machine

Categories:


Problem
Toad 8.6 installation on a 64-bit windows 7 machine gives error as below when trying to connect Database.

"ORA-12154: TNS:could not resolve the connect identifier specified"



Root Cause
64-bit Microsoft OS's install 32-bit applications into the following location
"C:\Program Files (x86)\..."
rather than the typical location of


"C:\Program Files\..."
This causes an existing networking bug to occur where the networking layer is unable to parse program locations that contain parenthesis() in the path to the executable which is attempting to connect to Oracle.


Solution
Uninstall Toad from the following location
C:\Program Files (x86)\Quest Software\Toad for Oracle\


and reinstall it in the following location
C:\Oracle\Quest\Toad 9.1
(Any other location having no parenthesis in the path)

Spread The Love, Share Our Article

Related Posts

1 Response to Toad Connection Error on a Windows 64-bit Machine

May 25, 2011 at 10:15 AM

Thanks.... I have this problem too :P

Post a Comment