locked
Error connecting Oracle SQL Developer(2.1.1.64) from asp.net RRS feed

  • Question

  • User-1113126456 posted

    Hi

    I am getting following error when i am connection to the database from asp.net application. I am using Oracle SQL Developer(2.1.1.64)

    Oracle.DataAccess.Client.OracleException was caught
      Message=""
      ErrorCode=-2147467259
      StackTrace:
           at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
           at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
           at Oracle.DataAccess.Client.OracleConnection.Open()
           at AZ.SamplingUILibrary.ModelObjects.DataAccessManager.Open() in C:\AZ\DesignSampleCentral3.5\SampleCentralUI\SamplingUILibrary\ModelObjects\DataAccessManager.cs:line 32
           at AZ.SamplingUILibrary.ModelObjects.DataAccessManager.OracleSelectDT(String sql) in C:\AZ\DesignSampleCentral3.5\SampleCentralUI\SamplingUILibrary\ModelObjects\DataAccessManager.cs:line 157
      InnerException:

    DataAccessManager.cs is page where i have written connection stuffs

    public string OracleConnectString
                {
                    get
                    {
                        string connectconfigString = MO.Constants.CONNECTIONSTRING_ORACLE + System.Configuration.ConfigurationManager.AppSettings["DBInstanceTarget"];
                        string connectString = System.Configuration.ConfigurationManager.AppSettings[connectconfigString];
                        return connectString;
                    }
                }

     private void Open()
                {
                    if (con == null)
                    {
                        con = new Oracle.DataAccess.Client.OracleConnection(OracleConnectString);
                    }
                    con.Open();
                }

    Can anyone tell me what may be the problem. Iguess this is not a version problem. I am using Oracle SQL Developer(2.1.1.64)

    Wednesday, December 14, 2011 7:13 AM

All replies

  • User551462331 posted

    seems problem is in connectionstring

    debug u r code and see what is the value of

    string connectString = System.Configuration.ConfigurationManager.AppSettings[connectconfigString];

    the oracle sql developer u r using is just a tool... it has nothing to do with actual database... what is the version of Oacle database u r using

    like 9i, 10, 11 etc.?

    Wednesday, December 14, 2011 7:31 AM
  • User1501365188 posted

    check ur connectconfigString value and also check connectString  both are not null

    Wednesday, December 14, 2011 7:32 AM