469,610 Members | 1,773 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,610 developers. It's quick & easy.

Get_DBTIMESTAMP in C#error while retrieving date

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
Sep 30 '06 #1
0 998

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

13 posts views Thread by RHPT | last post: by
1 post views Thread by whitehorse | last post: by
9 posts views Thread by Martin | last post: by
6 posts views Thread by Geoff Cox | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.