7 Replies Latest reply: Sep 17, 2012 11:03 AM by 878626 RSS

    Year month and day parameters describe an un-representable datetime

    962484
      Hi,

      I am retrieving data from one of table using odp.net (oracle data access 4.0); following is the c# code.

      The folloiwng code is just to retrieve data from a table and bind the data to dataset for further manipulation.

      string oradb = "Data Source=(DESCRIPTION="
      + "(ADDRESS=(PROTOCOL=TCP)(HOST=1234)(PORT=5678))"
      + "(CONNECT_DATA=(SERVICE_NAME=01239)));"
      + "User Id=testtesttest;Password=passwordsample;";
      OracleConnection conn = new OracleConnection();
      conn.ConnectionString = oradb;
      conn.Open();
      string sql = "SELECT * from tbl1009715";
      OracleDataAdapter da = new OracleDataAdapter(sql, conn);
      DataSet ds = new DataSet();
      da.Fill(ds);

      While filling the dataset i am geeting the error; - Year month and day parameters describe an un-representable datetime

      Can anyone help me - what this error is and how to fix this error.

      Thanks in advance.

      Mike