Connectivity Cross Version Compatibility (SQL Server Compact 3.5)

Connectivity Cross Version Compatibility   This blog post explains the Merge Replication connectivity cross version compatibility scenarios for the SQL Server Compact 3.5 release. For more information about the connectivity cross version compatibility scenarios in SQL Server Compact 3.1, see SQL Server Compact 3.1 Connectivity Tools.   This post is not applicable/refer-to Sync Services for…

12

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 2) Can’t find P/Invoke DLL sqlceme35.dll 3) Can’t find P/Invoke DLL sqlceme40.dll   What…

19

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)      Virtual Memory is too low to load the dll 2)  …

4

SqlCeEngine/ISSCEEngine: Shrink Vs Compact

  The difference between these two is much similar to Internal and External Memory Fragmentation.  From SqlCeEngine.Shrink documentation, Reclaims wasted space in the database by moving empty and unallocated pages to the end of the file, and then truncating the file.  You can configure a database to automatically shrink by setting the autoshrink threshold option…

3

SQL Server Compact 3.5 Downloads

Microsoft SQL Server Compact 3.5 released with Visual Studio 2008. The English release of SQL Server Compact 3.5 is available on the download center and the links are as given below: 1. SQL Server Compact 3.5 and Synchronization Services for ADO.Net v1.0 for Windows Desktop: Installs the files for SQL Server Compact 3.5 and Microsoft Synchronization…

13

LINQ with SQL Server Compact (a.k.a. DLINQ with SQL CE)

  Querying data from Sql Server Compact database gets easier!    “LINQ”  stands for .net Language INtegrated Query.  LINQ-enabled languages can provide full type-safety and compile-time checking of query expressions, and development tools can provide full intellisense, debugging, and rich refactoring support when writing LINQ code.   What is LINQ to SQL?   LINQ to SQL provides a runtime…

11

Merge Subscribe Once, Copy and Deploy Multiple Times

  “Merge Subscribe Once, Copy and Deploy Multiple Times” – This has been the real good feature I like and unfortunately not many people knew about it.  This is applicable for v3.0 and above.  Here is a short story of it:   The initial subscription is going to bring down lot of data from server…

1

HOWTO: Pending Changes for a Merge Subscription (Server Side)

  Earlier in the other blog article we discussed on “HOWTO: Pending Changes for a Merge Subscription (Client Side)” and this article will focus on finding the pending changes on server side for download.  This blog article requires a little understanding of Remote Data Access (RDA).  Note that, RDA does NOT need any extra configuration…

1

HTTP/Internet Proxy Detection – Using WINCE API

  SqlCeReplication and SqlCeRemoteDataAccess have InternetProxyServer, InternetProxyLogin, InternetProxyPassword properties which the application can set to make these sync protocols communicate via/thru the desired proxy.   However, then the question comes on how to programmatically detect the HTTP/Internet proxy settings from the app to set the properties on SQL CE classes.  Here is the short story…

3