473,790 Members | 3,083 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

1 New Member
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.
Jul 3 '06 #1
1 4224
DSwanson
1 New Member
Did anyone ever recieve an answer to this one? We are have the same exception on DataAdapter.Fil l when loading a row from table in Oracle9i and 10g. We are using the System.Data.Ora cleClient 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
Sep 28 '06 #2

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

Similar topics

0
1425
by: bardo | last post by:
Hi all, I have a Access *.MDB database. With multiple tables. One table (call it Table 1) is linked to all the others. (column is name indexID). If I load all the tables in a DataSet everything works great. But I know in the future this Database will get large. So it will take some time to load/ save everything using Adapter.Fill and Adapter.Update command.. I want to use the range in the Adapter.Fill overloads. On table 1 I can...
2
1273
by: Dan | last post by:
I've created a web form which fills a DataGrid with a DataSet generated from the SqlDataAdapter.Fill method. The adapter's query takes about 30 seconds to complete when I run it in the SQL Server Query Analyzer, but when I run it from my web page I kept getting a TimeOut exception. So then, as an experiment, I changed the way I created the adapter to the following: SqlConnection conn = new SqlConnection(m_Conn); SqlCommand sqlCommand =...
3
1028
by: Pawel Blochowiak | last post by:
Hello Everybody SqlConnection conn = new SqlConnection(str); DataSet dataSet = new DataSet(); SqlDataAdapter dataAdap = new SqlDataAdapter("select * from Region", conn); conn.Open(); dataAdap.Fill(dataSet, "Region");
1
3234
by: Siegfried Heintze | last post by:
I'm using a third party hosting service. I presently have a Web Service on this hosting service's server that loads and executes a native mode DLL. This demonstrates that the hosting service has given me proper access to the temporary directory c:/Windows/Microsoft.NET/Framework/V1.1.4322/Temporary ASP.NET Files/root/...." I believe it also demonstrates that I have access to c:/documents and settings/xyz/aspnet/local settings/ ...
2
6086
by: Stanav | last post by:
Hello all, I'm developing a web application using VB.Net 2003 and Framework 1.1. This application queries an AS/400 database. I'm using the IBM OleDb provider that came with IBM Client Access for Windows (V5R3). Everything works fine on my development PC, but when I move the application to a Windows Server 2003, it crashes when trying to fill a dataset. I've double-checked that the Win 2k3 server does have Client Access installed, that it...
3
4623
by: Stanav | last post by:
Hello all, I'm developing a web application using VB.Net 2003 and Framework 1.1. This application queries an AS/400 database. I'm using the IBM OleDb provider that came with IBM Client Access for Windows (V5R3). Everything works fine on my development PC, but when I move the application to a Windows Server 2003, it crashes when trying to fill a dataset. I've double-checked that the Win 2k3 server does have Client Access installed, that it...
0
2148
by: dalaeth | last post by:
I have searched Google high and low and haven't found anything that works. Here's my problem, hopefully someone will be able to help! I'm using 1.1 Framework, and ODP.NET 9.5.0.7 on a Windows 2003 Server. I have a cached DataSet that I fill using an OracleDataAdapter. Changes are made to that dataset in memory and as rows are changed, they are updated back to the database using OracleDataAdapter.Update(DataRow). Every few minutes, I...
0
4561
by: mike1402 | last post by:
Hi ! I get the error below sometimes when retrieving a big amount of data using Datadapter.Fill(dataset,"table"). But when I send the command Fill again, there is no error. Is it a fault of IBM.Data.DB2.iSeries; Version: v1.0.3705 (is there an newer one for OS/400 Version ist V5R3 ?) or is it a hardware faoult (memory of as400 or pc) ? br mike Es wurde versucht, im geschützten Speicher zu lesen oder zu schreiben. Dies ist häufig ein...
2
4210
by: slinky | last post by:
I'm getting a error when I open my . aspx in my browser... line 34: da.Fill(ds, "Assets") Here's the error and my entire code for this .aspx.vb is below that ... I need some clues as to what is causing the error... Thanks!!! Server Error in '/' Application. ---------------------------------------------------------------------------­----- Multiple-step OLE DB operation generated errors. Check each OLE DB
0
9666
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9512
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9987
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9023
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7531
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6770
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4100
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3709
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2910
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.