Re: TNS Protocol Adapter Error (Oracle 9i) - Urgent

saurabhgarg2k_at_gmail.com wrote:

> We are facing a very strange problem, we have an Oracle 9i Server
> running , the problem came into picture when we tried to connect to the
> database through ASP.NET application using ODP.NET, it throws an error
> "ORA-12560 TNS Protocol Adapter Error",
<snipped>

Seeing that TNSPING does work, it means that the Oracle Client Software is working and configured.

If another piece of software fails, it likely means there's a problem with that software using the Oracle Client Software. In the Windows environment that can mean problems with security, access control lists and authentication. In other words, a screwup in the Registry aka The Basket That Holds All The Configuration Eggs In Binary Format. IMO, the single biggest design flaw in Windows.

--
Billy