473,804 Members | 3,273 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

OLEDB Connection with Oracle

I got this error on production and I rebooted the server
and the problem went away. It happens at random.

Please help.
Environment W2K with Oracle 9.2 client connected to oracle
using oracle.oledb provider

Specified argument was out of the range of valid values.
Parameter name:
Hour, Minute, and Second parameters describe an
unrepresentable DateTime.
Description: An unhandled exception occurred during the
execution of the
current web request. Please review the stack trace for
more information
about the error and where it originated in the code.

Exception Details: System.Argument OutOfRangeExcep tion:
Specified argument
was out of the range of valid values. Parameter name:
Hour, Minute, and
Second parameters describe an unrepresentable DateTime.

Source Error:

An unhandled exception was generated during the execution
of the current web
request. Information regarding the origin and location of
the exception can
be identified using the exception stack trace below.

Stack Trace:

[ArgumentOutOfRa ngeException: Specified argument was out
of the range of
valid values. Parameter name: Hour, Minute, and Second
parameters describe
an unrepresentable DateTime.]
System.DateTime .TimeToTicks(In t32 hour,
Int32 minute, Int32 second) +90
System.Data.Ole Db.DBBindings.G et_DBTIMESTAMP( IntPtr
buffer) +200
System.Data.Ole Db.DBBindings.g et_Value_DBTIME STAMP() +17
System.Data.Ole Db.DBBindings.g et_Value() +1118
System.Data.Ole Db.OleDbDataRea der.GetValues(O bject[]
values) +104
System.Data.Com mon.SchemaMappi ng.LoadDataRow( Boolean
clearDataValues ,
Boolean acceptChanges) +61
System.Data.Com mon.DbDataAdapt er.FillLoadData Row
(SchemaMapping mapping) +155
System.Data.Com mon.DbDataAdapt er.FillFromRead er(Object
data, String
srcTable, IDataReader dataReader, Int32 startRecord, Int32
maxRecords,
DataColumn parentChapterCo lumn, Object parentChapterVa lue)
+260
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet,
String srcTable,
IDataReader dataReader, Int32 startRecord, Int32
maxRecords) +129
System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object
data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand
command,
CommandBehavior behavior) +304
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet,
Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior
behavior) +77 System.Data.Com mon.DbDataAdapt er.Fill
(DataSet dataSet) +38
TTI.CES.dbGener al.GetGenericDa taSet(DBOptions db, String
connStr, String
query, ArrayList param, Boolean UseWorkFlowConn Str,
CommandType CommandType)
in
C:\Projects\ces dotnet\CESWeb\C lasses\Data\dbG eneral.vb:37
TTI.CES.Workflo w.clsQuote.GetQ uoteList(String strAction,
Int64 lngQuoteID,
Int64 lngPGMID, CESUser objUserInfo) in
C:\Projects\ces dotnet\CESWeb\W orkflow\Classes \clsQuote.vb:1
44
TTI.CES.Workflo w.QuoteList.Bin dData(String strAction,
Int32 intQuoteId,
Int32 intPgmid) in
C:\Projects\ces dotnet\CESWeb\W orkflow\Pages\Q uoteList.aspx.
vb:112
TTI.CES.Workflo w.QuoteList.Pag e_Load(Object sender,
EventArgs e) in
C:\Projects\ces dotnet\CESWeb\W orkflow\Pages\Q uoteList.aspx.
vb:41
System.EventHan dler.Invoke(Obj ect sender, EventArgs e) +0
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
System.Web.UI.C ontrol.LoadRecu rsive() +35
System.Web.UI.P age.ProcessRequ estMain() +731
Jul 21 '05 #1
0 5810

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2499
by: Tzanko | last post by:
Hi, We are using ADO with the Otacle Provider for OLEDB in our COM+ MTS C++ client (Oracle 8.1. It seems there is no way to timeout our ORACLE SQL calls, in case the database is verry slow for what-ever reason. Our calls just wait for the SQL to complete and we do not seem to have any control over the time it takes. The normal way to achive this in ADO is by setting the ConnectionTimeout and CommandTimeout properties of the ADO's...
0
1914
by: Error while executing SP | last post by:
Hi, I am getting an error while executing a sp from Oracle database. Can you let me know what could be the problem? here is the code using(System.Data.OleDb.OleDbConnection cn = new System.Data.OleDb.OleDbConnection()) { cn.ConnectionString="Provider=OraOLEDB.Oracle;Password=STORED_OBJ;User ID=STORED_OBJ;Data Source=PDCDGL1.NA.HPFS.COM;Extended Properties=;Persist Security Info=False;PLSQLRSet=1;"; cn.Open(); //String strProcName =...
2
2970
by: David R. Longnecker | last post by:
While attempting to migrate from my old "loop through all records" mindset with ADO 3.0 and into the ADO.NET arena, I've come across an issue using DataGrids with the OLEDB and Oracle data connection objects. I began using the C# MSDN article (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbwlkWalkthroughUsingDataGridWebControlToReadWriteData.asp) on DataGrid web controls and was very successful until... --...
5
9657
by: petro | last post by:
Hello all, My asp.net web application works on my machine but I get the following error on our test web server, There is only one oracle home on the test server. Does anyone know how to resolve this error? Oracle error occurred, but error message could not be retrieved from Oracle. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the...
1
1695
by: feng | last post by:
I need a connection string to use for OleDb for Oracle .Net provider (NOT through ODBC!). Can someone point me to some doc or give me some examples? Thanks
0
389
by: Prabhakar Chola | last post by:
I got this error on production and I rebooted the server and the problem went away. It happens at random. Please help. Environment W2K with Oracle 9.2 client connected to oracle using oracle.oledb provider Specified argument was out of the range of valid values.
1
2118
by: ori | last post by:
Hi, I have an ASP.Net application hosted in a windows server 2003 (IIS 6.0). The application uses a Oracle Database to retrieve some data through an Oledb connection. I've set the IIS application pool used by the application to get recycled when the application consumes too much memory which it ocasionally does and I don't want the server to hang. After this I stress the application to know it's performance and monitor it's...
0
2111
by: varughmi | last post by:
A unique issue has cropped up today in a .NET program I developed. It has been working fine for over an year until now. The program makes 2 connections total - one to a UNIT instance and another to TEST instance. Both instances are running Oracle 10g. The program is able to connect (using OLEDB provider) to both the instances separately one-at-a-time. However, when attempting to open the second connection while the first is already open,...
1
1375
by: Muhamamd Khayyam | last post by:
I am passing a query to Oracle 9i using Oledb.command object. Code is Dim c As OleDb.OleDbCommand Dim sOURCE As BindingSource Dim DR As OleDb.OleDbDataReader Connect.Connect("scott", "tiger", "ORCL", "ORACLE") ' A module for connection string c = New OleDb.OleDbCommand("select * from EMP WHERE HIREDATE = '07-AUG-07', Connect.V_DbConnection) '' Connect.V_DbConnection is a connection object ...
0
10337
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10323
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10082
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
9160
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...
0
6854
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();...
0
5654
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4301
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
3822
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2995
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.