I am using a simple select query in C# app that fetches a row which has a datatime field.
The query is simple "SELECT * FROM THE USERS WHERE USER_NAME = 'ABC' ",
the users table contains a datetime field , it is an oracle table
This app works fine on my developmet pc , but on the user PC it gives the following error .I am using OLEDB
Error Encountered: Specified argument was out of the range of valid values. Parameter name: Year, Month, and Day parameters describe an unrepresentable DateTime.; Stack Trace is at System.DateTime.DateToTicks(Int32 year, Int32 month, Int32 day) at System.Data.OleDb.DBBindings.Get_DBTIMESTAMP(IntPt r buffer) at System.Data.OleDb.DBBindings.get_Value_DBTIMESTAMP () at System.Data.OleDb.DBBindings.get_Value() at System.Data.OleDb.OleDbDataReader.GetValues(Object[] values) at System.Data.Common.SchemaMapping.LoadDataRow(Boole an clearDataValues, Boolean acceptChanges) at System.Data.Common.DbDataAdapter.FillLoadDataRow(S chemaMapping mapping) at System.Data.Common.DbDataAdapter.FillFromReader(Ob ject data, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDataReader dataReader) at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at AB.MSS.Common.PPSDataLayer.ExecuteDataTable(String astrSQL, OleDbConnection& acn, OleDbTransaction& atx, DataTable atblData)
has anyone faced this problem before ?Any resolutions