Friday, April 27, 2012

Error during the installation of Quest Toad

I have used Quest Toad for many years. I like Quest Toad as many other Oracle DBAs, especially when I worked for Quest ;-)

This week I finally got rid of my old laptop with Window XP and received a new laptop with 64-bit Windows 7. I installed Oracle 64-bit client and then installed Toad. The installation was successful without any error. However an error message "You have no Oracle clients installed" popped out when I launched Toad. The error is usually caused by no Oracle client installed, or Toad is installed before Oracle client, which is obviously not my case. I uninstalled and re-installed both Oracle client and Toad but got same error message. It made me think there might have some trick. So I searched online and found the following document,

https://support.quest.com/Search/SolutionDetail.aspx?ID=SOL39689

The reason is Toad does not support a 64-bit Oracle client! Everything works fine once I installed 32-bit Oracle client software.