We have a 11g set up on 2008 R2 box and can connect fine. We just installed Oracle 12c on Windows Azure VM and we can not get connected. We tested port 1521 to see if it was open and it is.
We are trying Direct connect and have SID checked.
FYI - Toad 9.7.X came out before 11gR2, so that version of toad could not be tested with 11gR2 or 12c - which are the only two officially supported versions of Oracle currently. So you really need to upgrade as that version of Toad is now 6 years old (Sep 2008). For example one possible error one might get with such an old version of Toad is that it may not recognize the newer Oracle client DLL’s and issue errors messages. You’re really in gray area using such old version of software - and it limits what we can do to assist …