Search code examples
c#wcfsqliteioerror

Using SQLite transactions I/O Error

I currently have a client / server setup where the client sends data to the server and then the server saves the data to a SQLite database file. To do this I am using transactions which works fine in windows 7 when I run around 30 clients (each client sending data back between 5 - 30 seconds).

When using the same software in Windows XP, I can get/set data multiple times with no problems until I run around 20 clients I start to get Windows Delayed wrote failed errors: alt text http://files.me.com/james.ingham/on1qb1

This fires an exception on the server: alt text http://files.me.com/james.ingham/hjoodv

I'm assuming this is either something to do with XP or a hardware issue on the machine i'm running XP.

Does anyone have any advice to avoid this? Or if I should just catch the exception and retry saving the data?

Solution

  • Sorry to answer my own question but this was a hardware issue! Just incase anyone else comes accross it!