I was able to resolve by following the steps at the following link
http://forums.asp.net/p/1012052/1353494.aspx
After restart I above error was resolved. Now however I am getting another error
ORA-12154: TNS:could not resolve the connect identifier specified
Complete message
Devart.Data.Oracle.OracleException was unhandled by user code
Message=ORA-12154: TNS:could not resolve the connect identifier specified
Source=Devart.Data.Oracle
ErrorCode=-2147467259
Code=12154
Offset=0
StackTrace:
at Devart.Data.Oracle.bo.b(Int32 A_0)
at Devart.Data.Oracle.ap.d(Int32 A_0)
at Devart.Data.Oracle.ap.a(t A_0, at A_1)
at Devart.Data.Oracle.OracleInternalConnection..ctor(t connectionOptions, OracleInternalConnection proxyConnection)
at Devart.Data.Oracle.b0.a(j A_0, Object A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, j A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionPoolGroup.a(DbConnectionPool A_0, DbConnectionBase A_1)
at Devart.Common.DbConnectionPool.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection)
at Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
at Devart.Common.DbConnectionBase.Open()
at Devart.Data.Oracle.OracleConnection.Open()
at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetNewOpenConnection()
at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetWrappedConnection()
at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetOpenConnection()
at Devart.Data.Oracle.EnterpriseLibrary.OracleDatabase.CreateOracleObject(String objectTypeName) in C:\StarTeam\Cash_CWF\Credits Workflow UI\src\lib\DevartEnterpriseLibrary\OracleDatabase.cs:line 251
at Davita.RevenueOperations.CreditsWorkflow.DataAccess.RuleRepository..ctor() in C:\StarTeam\Cash_CWF\Credits Workflow UI\src\Davita.RevenueOperations.CreditsWorkflow.DataAccess\RuleRepository.cs:line 23
at BuildUp_Davita.RevenueOperations.CreditsWorkflow.DataAccess.RuleRepository(IBuilderContext )
at Microsoft.Practices.ObjectBuilder2.DynamicMethodBuildPlan.BuildUp(IBuilderContext context)
at Microsoft.Practices.ObjectBuilder2.BuildPlanStrategy.PreBuildUp(IBuilderContext context)
at Microsoft.Practices.ObjectBuilder2.StrategyChain.ExecuteBuildUp(IBuilderContext context)
InnerException:
I am able to connect to the database using PLSQL developer Devart's Entity Developer and also Visual Studio's Server Explorer.
I am trying to resolve this error for the past one week but with no success. Any idea what could be wrong.
Mayuresh
PS: The same code works on other developers machine.