Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Troubleshooting   (RSS)
Wednesday, May 06, 2009 4:26 AM

Troubleshooting: Access Violation exception while using SQL Server Compact database with ADO.NET provider

Possible causes for Access Violation exception in general: An access violation occurs in unmanaged or unsafe code when the code attempts to read or write to memory that has not been allocated, or to which it does not have access. This usually occurs because
Posted by SQLCEBLOG | 0 Comments
Wednesday, April 01, 2009 1:16 PM

After moving the database from one platform to other, the first SqlCeConnection.Open() takes more time

If you move a SQLCE database from one platform to other, it's first SqlCeConnection.Open() takes more time and also increases the database file size. The Reason : F or an index on string type columns, SQLCE uses LCMapString API to get the normalized sort
Posted by SQLCEBLOG | 0 Comments
Wednesday, June 25, 2008 4:20 PM

Insight into SQL Server Compact database corruptions

Database corruptions are often the most painful bugs to repro and debug. A good percentage of the SQL Server Compact bugs reported are in this category. However it so turns out that in majority of the cases Compact is not the culprit. Surprised!! Let
Posted by SQLCEBLOG | 3 Comments
Filed under: ,
Wednesday, April 30, 2008 6:15 AM

Query performance

Understanding the reason for slowness of a SQL query and then tuning to boost it is a slightly complicated process, but it can be extremely rewarding in some cases. In this post, I am going to list down some ways in which you can tune the query performance
Posted by SQLCEBLOG | 2 Comments
Wednesday, December 12, 2007 10:18 AM

"Houston, we got some problem..." and "Houston, we got a problem..." - notice a difference?

So you have run into a problem - how to efficiently report this: System configuration: On a Desktop/Server, Run Winver from Start -> Run. On a Pocket PC, Start -> Settings -> About On a Smart Phone, a bit more steps - start -> Settings ->
Posted by SQLCEBLOG | 1 Comments
Filed under: ,
Friday, October 26, 2007 9:01 PM

Can’t find P/Invoke DLL sqlcemeNN.dll

I know this is very annoying, uninformative, directionless…blah blah… error. And, kindly pardon me for blogging about this error very lately. Better late than never and here it goes. What are the actual errors? 1) Can't find P/Invoke DLL sqlceme30.dll
Posted by SQLCEBLOG | 19 Comments
Filed under:
Friday, October 26, 2007 8:01 PM

Troubleshooting: Can’t load sqlce dll

SQL Server CE/Comapct uses Windows API LoadLibrary ( PlatformBuilder or WinCE or Win32 ) to load the DLLs. When LoadLibrary fails to load any SQL CE dll, we throw the error “Can’t load sqlce dll”. Now, let’s discuss more on why LoadLibrary can fail. 1)
Posted by SQLCEBLOG | 4 Comments
Filed under:
 
Page view tracker