Error when starting ArcPad 10.2.1 installed in Windows 7 ultimate,

Question

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

JamalNUMAN · Answer

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

Best

Jamal

RebeccaStrauch__GISP · Answer

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.

JamalNUMAN · Answer

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/