|
ASP.NET and Oracle connection error ORA-12154 -- kiran --
Hi All, I've one ASP.NET code which uses ODP.NET for oracle connection. This code is working fine on my colleagues' machines but not on mine. It throws an Oracle error: ORA-12154 TNS Name could not be resolved on objConn.Open() I m able to connect to db successfully through TOAD. (TNSNAMES.ORA file is perfect) I've also added access rights on Oracle directory for ASP.NET. Through Oracle Adapter of .NET i m able to connect and view tables. Please suggest on this. Regards, Kiran |
|
-- kiran --
Hey All, Found the solution!!! When I had given ASP.NET right on Ora92 folder, TNSNAMES.ORA file was absent. I had added it later on, because of which this file didn't have this right. As a consequence, .NET framework was unable to access this file to resolve TNS names. Also found another thing on net that - if TNSNAMES resolving fails, alternatively we can use these names' definitions directly in Connection String. This gave me the hint to check access rights on TNSNAMES.ORA Regards, Kiran |