I searched this website, used google and ask.com but couldn't find a solution.
I wrote a console application that connects to Oracle 8i database another ASP.NET application connecting to the same database executing the same query. I got an error while running the console application TNS: connection closed and unhandled exception but the ASP.NET application worked fine!
Weeks ago, the database administrator downloaded Oracle 8.1.7 on my machine (Windows 2000) so now I have Oracle 8.0 and 8.1.7. Could that be the problem? But then why did it work with asp.net application?