System.Data.SqlServerCe.SqlCeException: Bad Hash

Asked Dec 11 '15 at 00:29

Active Dec 11 '15 at 00:37

Viewed 251 times

I have an application that connects to an SQL Server Compact Edition 3.5 database. The application will randomly fail, throwing a SqlCeException with the message "bad hash." What is causing this exception and how can I prevent it? I can't find any information on google that might explain what's going on. The problem seems to be fixable with a reboot, but I would like to know more about what causes it and how to prevent it.

System.Data.SqlServerCe.SqlCeException: Bad Hash.
at System.Data.SqlServerCe.SqlCeConnection.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent)
at System.Data.SqlServerCe.SqlCeConnection.Open()

edited Dec 11 '15 at 00:37

asked Dec 11 '15 at 00:29

Karl Dickman

What version (build) of SQL CE 3.5 do you use? – ErikEJ Dec 11 '15 at 06:45
Is your applicaion using multiple threads? And do you act accordingly (not share objects across threads) ? – ErikEJ Dec 11 '15 at 20:15
The application is single-threaded. – Karl Dickman Dec 11 '15 at 20:16
Suggest you improve your error handling and also share your connection string https://github.com/ErikEJ/SqlCeToolbox/blob/af796258b5ffe94b63a25687979f5d16d7d76ba8/src/API/Generator/Helper.cs#L302 – ErikEJ Dec 11 '15 at 20:49
Data Source=EDT.sdf;Max Database Size=4091;Password=the password to the database – Karl Dickman Dec 11 '15 at 21:08
What OS and Service Pack? – ErikEJ Dec 12 '15 at 07:35
Windows 7 Service Pack 1. I took your advice and added more detailed messages for SqlCeExceptions to the application error log. Haven't seen the bug pop up a gain in a while. – Karl Dickman Dec 14 '15 at 17:10

System.Data.SqlServerCe.SqlCeException: Bad Hash

0 Answers0