Microsoft SQL Server Compact Edition Initialization Error...

[AmberKarl]

I have a Mobilemapper CX and when I click to open ArcPad 7.1 I get this message..."Microsoft sql server compact edition initialization error 80040154. Arcpad will operate with some functionality disabled."

Does anyone know what this means and how to fix it?

[RebeccaStrauch__GISP]

I was having the same error pop-up today, but on my Win7 laptop (my dev/test machine). I just installed 10.2.x and I'm working on upgrading my 7.1.1 custom apps. I did some research and these are the options I have found.

• For me, since it is not a mobile device and I am currently using shapefiles, I could 1) ignore the message, or 2) in arcPad, go to options->General Tab0>uncheck the box to check for sql As found in the old forum

http://forums.esri.com/Thread.asp?c=34&f=2360&t=241714#737341 Feb 19, 2008 entry by Brandi Saidy. That thread actually talks more about why they error occurs " The warning is caused by the SQL CE client not being installed on your device. The SQL CE client is the engine for the new Arcpad AXF geodatabase format. Use the new deployment manager application to install the SQL CE client and the message will go away." And has other good info. 


• there is a good esri knowledge base article on the new deployment manager fix http://support.esri.com/en/knowledgebase/techarticles/detail/34303

and  


• a microsoft support link talking about the "Windows Mobile Device Center" for win7 use

http://answers.microsoft.com/en-us/windows/forum/windows_7-windows_programs/windows-mobile-device-ce... which I downloaded and installed (run from Start->programs to accept the license agreement, then you can change connection settings), but it seems to have wanted a mobile device attached. so in my case, I'm not sure if this did any good. 


• The microsoft download and install instructions of the above can be found at http://support.microsoft.com/kb/931937 both 32 and 64 bit versions are available.

So, in my case since I am not yet using anything but shapefiles (and a tif basemap), I was able to just turn off the SQL check (see attached). If/when I start moving to another format, I may have to revisit this. [ATTACH=CONFIG]34691[/ATTACH]

I hope this helps.


-----
UPDATE: after working with Kevin B in tech support on another issue, he told me that if you install 10.2.1 as a clean install, (instead of updating from 10.0.4, for example), Microsoft SQL Compact Edition v3.1 MAY not get installed. In the process of debugging my other issue, we uninstall 10.2.1, and installed 10.0.4 which did installed the v3.1. And although this was unrelated to my other issue, when switching back to 10.2.1, the file was still there, and I no longer get the error message (even though the "Check for SQL" box is checked).

The folder is fairly small zipped, so I've attached it. If you unzip this folder to your Program Files folder .. if 32-bit OS or the "Program files (x86)" ...if 64-bit, that might also take care of the issue. However, since mine was installed from the 10.0.4 setup, I have not tried it.