Year month and day parameters describe an un-representable datetime
962484Sep 17 2012 — edited Sep 17 2012Hi,
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