Re: Adding record error ???
From: Darren Shaffer (darrenshaffer_at_discussions.microsoft.com)
Date: 10/25/04
- Next message: John Kendrick: "Re: Error 25081: Incorrectly generating identities after a merge"
- Previous message: Earl: "Re: SQL CE Server Tools with SQL SP3a"
- In reply to: Simon Says: "Adding record error ???"
- Next in thread: Simon Says: "Re: Adding record error ???"
- Reply: Simon Says: "Re: Adding record error ???"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 25 Oct 2004 08:15:40 -0600
Simon,
That HRESULT is explained here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;192141
but I haven't seen that before with SQL CE, so without seeing your
code and schema, it's hard to help you.
One tip - be sure you're using a parameterized query if you're
inserting/updating 500 records in a loop - it'll be 3-5x faster.
-Darren
"Simon Says" <tengsimon@hotmail.com> wrote in message
news:ed7TI4juEHA.1292@TK2MSFTNGP10.phx.gbl...
> Dear all,
>
> I tried to add in 500 records (all same values) continuously just for
> brenchmarking purposes, but everytime it stops at 139th record with an
> sqlceException. The exception contains no message, but has an HResult
> = -2147024882. Anyone know what it means?
>
> --Simon Teng
>
>
- Next message: John Kendrick: "Re: Error 25081: Incorrectly generating identities after a merge"
- Previous message: Earl: "Re: SQL CE Server Tools with SQL SP3a"
- In reply to: Simon Says: "Adding record error ???"
- Next in thread: Simon Says: "Re: Adding record error ???"
- Reply: Simon Says: "Re: Adding record error ???"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
