I have created an app that uses SQL Server CE, it's pretty cool, and way faster then the way I was doing it before.

However around every 120-130 updates it sends an error System.Data.SqlserCe.SqlCeException. (Note it crashes on a Query, so for each update there is one query so it's really around 240 sql queries when it dies.) The error message does not offer many details. I have to exit all the way out of the application before it will let me make another connection to the DB without crashing.

I thought maybe it was a ram issue and added a bunch of GC.Collect Statements but it did not help. I am using a Symbol MC 1000 and so I installed the software onto a PPT 8800, which has more ram. But I still got the same error at the same place.

I wouldn't even mind If I just had to reset the SQL connection, but I can not get it to connect to the SQL CE DB unless I exit all the way out of my program.