Fill dataset is throwing out of the range of range exception.

[dedipya]

Environment W2003K with Oracle 10 client connected to oracle using oracle odp provider.orcle is on solaries machine.

while filling the dataset .net is throughing the error "argument was out of the range of valid values".

we are getting error when trying to fill the dataset with more than 16 columns.

if any date column is avaible in retrivels then fill dataset method is throwing the bellow error.

Parameter name: Year, Month, and Day parameters describe an unrepresentable DateTime.

otherwise with out any date column then .net is throwing the bellow error.

arithmetic operation overflow

what could be the reason.when we conncted to oracle windows version it is working fine(if more then 16 columns also)

we are facing the problem becouse of oracle database on solaries or any other reason?

Any help or any document or any URLs regarding this issue will be appreciated.

Thanks in advance.

[DSwanson]

Did anyone ever recieve an answer to this one? We are have the same exception on DataAdapter.Fill when loading a row from table in Oracle9i and 10g. We are using the System.Data.OracleClient adapter.

I am wondering if there is something odd in the database configuration that is not immediately evident by just doing a describe on the table. I say this because we have another table with a date column and we can fetch rows from that column without a problem. Also, we did not have this issue until we moved to a new database (and new dba).

So, it would seem something environmental with the host hardware or database configuration / table/column configuration is wrong or different.

Hope someone has some answers.

Thanks much, David