topic Re: Error when starting ArcPad 10.2.1 installed in Windows 7 ultimate, in ArcPad Questions

Error when starting ArcPad 10.2.1 installed in Windows 7 ultimate,

JamalNUMAN — Fri, 08 Aug 2014 15:57:46 GMT

Error when starting ArcPad 10.2.1 installed in Windows 7 ultimate,

Both ArcPad 10.2.1 and Windows 7 are installed on Algiz 7 machine

http://www.handhelduk.com/regions/uk/algiz-7.asp

As the ArcPad is started, I got the message below “Microsoft SQL Server Compact Edition initialization error”

What might be the issue here?

Thank you

Best

Jamal

Re: Error when starting ArcPad 10.2.1 installed in Windows 7 ultimate,

RebeccaStrauch__GISP — Sat, 23 Aug 2014 19:00:21 GMT

i had a similar issue and have a response in this older thread

Microsoft SQL Server Compact Edition Initialization Error...

A snippet from that thread

"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.

...
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."

https://community.esri.com/servlet/JiveServlet/download/381143-37437/Microsoft%20SQL%20Server%20Compact%20Edition.zip

that link is the .zip file mentioned.

You may want to look at the other thread for more detail.

Re: Error when starting ArcPad 10.2.1 installed in Windows 7 ultimate,

JamalNUMAN — Sun, 24 Aug 2014 18:14:49 GMT

Thanks Rebecca,

Do you mean that I need to install the two software below?

Microsoft SQL Server Compact 4.0

http://www.microsoft.com/en-us/download/details.aspx?id=17876

SQL Server Compact & SQLite Toolbox

http://sqlcetoolbox.codeplex.com/

Re: Error when starting ArcPad 10.2.1 installed in Windows 7 ultimate,

RebeccaStrauch__GISP — Mon, 25 Aug 2014 15:58:46 GMT

Hi Jamal,

Here is a quote from the tech support issue I had "when ArcPad 10.0 gets installed, it will install the Microsoft SQL Server Compact Edition v3.1 in the Program Files directory. The Microsoft SQL Server Compact Edition format is what the AXF file format is based on. Therefore because ArcPad 10.2.1 did not install that on the machine, that error was being produced. ArcPad will run successfully but will not be able to open AXF files. Throughout our troubleshooting, we ended up uninstalling 10.2.1 for ArcPad and reinstalling 10.0.4 and that had installed the Microsoft SQL Server Compact Edition v3.1, which resolved that error. We then removed 10.0.4 and reinstalled 10.2.1."

So, although I was told I could directly install/copy the v3.1 files, because of the other issues I was troubleshooting, I had uninstalled the 10.2.1 and installed an 10.0.x .... then reinstalled 10.2.x. That is not a direct approach but worked best for me at the time. Is that an option for you?

If not, the more direct approach would be to unzip the zip file

https://community.esri.com/servlet/JiveServlet/download/381143-37437/Microsoft%20SQL%20Server%20Compact%20Edition.zip

and copy the files to

C:\Program Files (x86)\Microsoft SQL Server Compact Edition\v3.1

that was what I would have done if the uninstall and reinstall didn't fix it for me.

Hope that helps.

Re: Error when starting ArcPad 10.2.1 installed in Windows 7 ultimate,

JamalNUMAN — Fri, 29 Aug 2014 19:24:02 GMT

Many thanks Rebecca for the help. This is very useful.

Best

Jamal