Strange ORA-12154 issue
Posted: Thu 24 Mar 2011 08:59
Hi,
I'm currently stuck by a really strange behavior. I have one existing C# Visual Studio solution I loaded from SVN on to my computer (Win 7 64 bits). It consists of 3 projects, one business layer that has a LINQ to SQL data context implemented one MVC application and one test project.
However I can't connect to the target server, instead I get an ORA-12154 error from either the MVC project or the test project.
I have Oracle client 10g installed
However when I try to connect using sqlplus, it works and when I create a NEW console project, add it to the existing solution and open an OracleConnection it also works. More interesting is that when, from my new console application, I put a reference to the business layer, the data context works perfectly. All projects are using the same Devart assemblies (6.10.121)
Also interesting to denote is that I cannot connect to that database from the Entity Developer (with or without explicitly specifying the oracle home)
I don't understand why I CAN connect from sqlplus and from a new console application but I CAN'T connect from existing application and from Entity Developer.
Is there a way we can enforce the path to oci.dll ? (my PATH contains already the oracle client home location)
Any idea, suggestion ?
I'm currently stuck by a really strange behavior. I have one existing C# Visual Studio solution I loaded from SVN on to my computer (Win 7 64 bits). It consists of 3 projects, one business layer that has a LINQ to SQL data context implemented one MVC application and one test project.
However I can't connect to the target server, instead I get an ORA-12154 error from either the MVC project or the test project.
I have Oracle client 10g installed
However when I try to connect using sqlplus, it works and when I create a NEW console project, add it to the existing solution and open an OracleConnection it also works. More interesting is that when, from my new console application, I put a reference to the business layer, the data context works perfectly. All projects are using the same Devart assemblies (6.10.121)
Also interesting to denote is that I cannot connect to that database from the Entity Developer (with or without explicitly specifying the oracle home)
I don't understand why I CAN connect from sqlplus and from a new console application but I CAN'T connect from existing application and from Entity Developer.
Is there a way we can enforce the path to oci.dll ? (my PATH contains already the oracle client home location)
Any idea, suggestion ?