OleDb DataFactory bug. Watch out.

From: "Bob" <bob@xxxxxxxxxxx>
Date: Fri, 17 Nov 2006 09:38:07 +1300

Hi,
Using the OleDb factory.
Asked it to insert 4K records into a SQLAnywhere database table.
Runs out of steam at record 244 and starts writing corrupted versions of
243 primary index column until at 248 it hits a variation it has already
written and fails with a non-unique primary index error.

Use a hand rolled OleDb command and the data is written OK. Likewise the SQL
Factory writes the same data to an SQLServer OK.

It is not a race condition as you can step through the failing iteration and
it still fails.
So...
Stay away from the OleDb Data factory until it is repaired.
Bob

.

Follow-Ups:
- Re: OleDb DataFactory bug. Watch out.
  - From: Nicholas Paldino [.NET/C# MVP]

Prev by Date: Cannot apply indexing with[] to an expression of type method group
Next by Date: Re: VS2005 - 64bit - processor
Previous by thread: Cannot apply indexing with[] to an expression of type method group
Next by thread: Re: OleDb DataFactory bug. Watch out.
Index(es):
- Date
- Thread

Relevant Pages

Re: OleDb contra SqlClient
... >> kostet das mit ner Factory spezifisch zu lösen, ... > nur wissen, was an OleDB so schlecht ist, und jetzt unterstellst du ihm ... > Nette Bugs hier und da. ... > Keyboard Error or No Keyboard Present ...
(microsoft.public.de.german.entwickler.dotnet.csharp)
Re: OleDb contra SqlClient
... >> kostet das mit ner Factory spezifisch zu lösen, ... > nur wissen, was an OleDB so schlecht ist, und jetzt unterstellst du ihm ... > Nette Bugs hier und da. ... > Keyboard Error or No Keyboard Present ...
(microsoft.public.de.german.entwickler.dotnet.csharp)
Re: OleDb DataFactory bug. Watch out.
... Are you writing a general-purpose tool, ... Using the OleDb factory. ... written and fails with a non-unique primary index error. ...
(microsoft.public.dotnet.languages.csharp)
Re: Oledb* Or SQL* classes
... If you used OleDb originally, ... situation where you were using a non-native provider or you'd have the ... A factory will allow you to specify what's what and create objects ... procs the same way sql server does and it has different datatypes. ...
(microsoft.public.dotnet.framework.adonet)
Re: OleDb DataFactory bug. Watch out.
... The app has to sit on top of either an SQlserver db or an SQLAnywhere db. ... Narrowed it down in fact not to the factory, ... only set its dbType property to String it gave the corruption. ... Using the OleDb factory. ...
(microsoft.public.dotnet.languages.csharp)