Reputation: 171
When I create a new instance of SqlCeConnection
it takes too long to create.
connection = new SqlCeConnection ();
This line in my program takes about 30 seconds to complete. This started happening to me recently, so when I run the program in another system it does it instantly.
I have added a reference to the System.Data.SqlServerCe.dll
of the Microsoft SQL Server Compact 4.0, and I have tried doing the local reference, and it does not help either. I would like to know why this happens?
Thanks
Upvotes: 1
Views: 120
Reputation: 41799
Could be certificate or registry key issue, see my blog post here: http://erikej.blogspot.dk/2013/08/faq-why-is-opening-my-sql-server.html?m=1
Upvotes: 1