I have a curious problem: In one place of my WinForms app, a large number of
.ExecuteScalar calls are executed (about 1000). On my PC this fails about
80% way through. I'm using Windows XP Pro SP1.
I've tried to isolate any environmental issues and have tested on:
* a VM running Japanese Windows XP SP1 - works fine
* several colleagues who have English Windows XP SP1 - didn't work for them
* a few colleagues who have English Windows XP SP2 - works fine
The version of MDAC on these different machines vary from 2.7 to 2.8, with
no apparent correlation to the failure/success of the .ExecuteScalar calls.
It appears as if this problem is related to the XP Service Pack (but the
fact that no problems found on Japanese Windows with SP1 contradict this
Has anybody come across this or have any ideas?