Hi Nicholas,
Thanks for your reply.
The app has to sit on top of either an SQlserver db or an SQLAnywhere db.
The idea of generic calls in the Dataclass was obviously appealing.
Narrowed it down in fact not to the factory, but to the DbParameter
When using the factory I was getting a generic DbParameter and setting its
DbType property to string. The corruption occured.
When I was not using the factory I was declaring an OleDbParameter and
setting its OleDbType property to Varchar. The data imported.
I found that if I didn't use the factory and declared an OleDbParameter and
only set its dbType property to String it gave the corruption.
Inspection of the OleDbType property in this situation showed that it had
been set to VarWChar by the Framework (the tooltip shows that VarWChar maps
to System.String)
I then set the OleDbParameter OleDbType to VarWChar and was able to bring
the corruption on.
So exactly how deep the weakness is remains unclear. It may be the
SqlAnywhere drivers.
Time for a cuppa coffee and a rethink.
regards
Bob
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.comwrote in
message news:Oq**************@TK2MSFTNGP03.phx.gbl...
Bob,
I almost would NEVER use the OleDbFactory class to generate commands
for
me. SqlFactory is one thing, since it is tailored specifically for Sql
Server. However, OleDb has to deal with a plethora of different providers
(the same thing applies for the OdbcFactory as well).
Are you writing a general-purpose tool, or are you writing something
more specific?
Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com
"Bob" <bo*@nowhere.comwrote in message
news:O7**************@TK2MSFTNGP03.phx.gbl...
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