Interactive Reporting - WIN 7 & the TNSNames.ora file (Oracle Error -1 : ORA-12170:)
A .txt extension may be added to the TNSNames.ora file by WIN 7 which will cause this file to not be found and a Oracle server connection is not possible. The TNSNames.ora file may be corrupted in other ways as well or you may be denied access when attempting to place the file in the Oracle path.
Oracle Error -1 : ORA-12170:
TNS:Connect timeout occurred
One problem might be a .txt extension has been added to your TNSNames.ora file. If your 'extensions' are hidden you will not see that .txt extension. Expand you file extensions so you can see if this is the problem. If you are able to remove that extension the connection can be established.
To avoid problems with corrupting the TNSNames.ora file you should use Notepad when opening and moving the file. Other applications may left justify the file creating problems as well.
The correct way to use Notepad on a WIN 7 operating system is to go to the application in Programs-->Accessories-->Notepad and right click on it to select 'Run as Administrator'. This should eliminate the .txt extension from being added and stop you from being 'Denied access' when placing the file in the Oracle path.
If this is not the cause of your problem please contact the DoIT Help Desk at (608) 264-4357 and select option 2.