none
Internal .Net Framework Data Provider error 30. RRS feed

  • Question

  • Hi all,

    I am using the following code for connecting to oracle database but I am getting as Internal .Net Framework Data Provider error 30.. This code was working fine from the last 3 or 4 months but now suddenly it is giving the error..

    My Code..

         using (OracleConnection connection = new OracleConnection(@"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=esdbdb02.eai.ae)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD)(INSTANCE_NAME=PROD2)));Persist Security Info=True;User ID=appsro;Password=appsro;Unicode=True"))

                {

                    if (connection.State == ConnectionState.Closed)

                        connection.Open();

                    using (OracleCommand cmd = connection.CreateCommand())

                    {

                        string commandText = string.Format("SELECT * FROM {0}", "APPS.XXEAI_EMPLOYEE_DOB_V");

                     //   string commandText = string.Format("SELECT * FROM tab");

                        DataSet ds;

                        try

                        {

                            cmd.CommandText = commandText;

                            OracleDataAdapter da = new OracleDataAdapter(cmd);

                            ds = new DataSet();

                            da.Fill(ds);

                            connection.Close();

                         

                          

                        }

                        catch (Exception ex)

                        {

                            Console.Write(ex.Message);

                        }

                    }

                }

    Sunday, October 14, 2012 10:38 AM

All replies