Error while connecting Oracle SQL Developer(2.1.1.64) from asp.net

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)

Answer 1

User269602965 posted

try 
{
using (OracleConnection conn = new OracleConnection({connectionStringnameinwebconfig}))
   {
  conn.Open();
    }
    } 
    catch (Exception ex)
    {
}