5 Replies Latest reply: Oct 19, 2011 8:13 AM by 895050 RSS

    ORA-12154: TNS:could not resolve the connect identifier specified

    895050
      Hi All,

      I am using oracle providers for asp.net to maintain session state in oracle database.For that
      1. I did install ODAC 11.2.0.2.1 and run the necessary scripts in oracle database
      2. I am using the following session mode and connection string in web.config

      <sessionState mode="Custom" customProvider="MyOracleSessionStateStore">
      <providers>
      <add name="MyOracleSessionStateStore" type="Oracle.Web.SessionState.OracleSessionStateStore,Oracle.Web, Version=2.111.6.20, Culture=neutral,PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString1"/>
      </providers>
      </sessionState>

      <connectionStrings>
      <add name="OraAspNetConString1" connectionString="data source=XXXXX;User Id=XXXX;Password=XXXXX;" providerName="Oracle.DataAccess.Client"/>
      </connectionStrings>.



      My application is working fine if the session state mode is set to inproc or state server modes but for custom mode, I anm getting following error
      ORA-12154: TNS:could not resolve the connect identifier specified.
      and show the error line at
      <add name="MyOracleSessionStateStore" type="Oracle.Web.SessionState.OracleSessionStateStore,Oracle.Web, Version=2.111.6.20, Culture=neutral,PublicKeyToken=89b483f429c47342" connectionStringName="OraAspNetConString1"/>


      Can any body help me ?

      Thanks
      Kishore

      Edited by: 892047 on Oct 18, 2011 9:41 PM