DbDataAdapter error when update oracle table

=?Utf-8?B?TmFwbw==?=

Guest

Posts: n/a

17th May 2005

Hi:
I use System.Data.Common.DbDataAdapter.Update() method to
insert/update/delete an oracle table. When i call it to insert the value of
dataset into table, it is correct.Then i try to mark all data in dataset as
"deleted" and insert it again, there is an error of "Unspecified error:
E_FAIL(0x80004005)" . I think oracle is a begin ...commint databse, i don't
know if the DbDataAdapter can commit it auto. i change to sqlserver using
same source code. it run correctly. So why it is not correct on oracle? How
to fix it?

« UpdateCommand not returning correct value to DataSet | DataSet Transactions Help »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DbDataAdapter.Update issue	Gamaka	Microsoft Dot NET Framework	1	24th Jan 2007 05:46 PM
DbDataAdapter.Update does nothing	Olivier Matrot	Microsoft ADO .NET	1	26th Jun 2006 02:52 PM
Re: Update Oracle table from Access table	Paul Clement	Microsoft ADO .NET	0	29th Jul 2004 07:04 PM
Re: Update Oracle table from Access table	Stephen B. Hahn	Microsoft ADO .NET	0	28th Jul 2004 08:28 PM
Re: Update Oracle table from Access table	Roy Fine	Microsoft ADO .NET	0	28th Jul 2004 04:30 AM