We program and integrate Beckhoff controls. Call us if you need
help programming or starting up a Beckhoff system.
Call +1 (763) 234-3407
Email nick@pcctrl.com
Posted to Beckhoff Blog on Aug 06, 2009
SQL Server Compact Edition (SQL Server CE) is a lightweight, yet powerful member of the
SQL Server 2008 family. It can be installed on either a Windows Mobile device or on a
full, desktop operating system.
For example, a common use of SQL Server CE is to store data locally on a handheld
device. This is often used in data collection and inspection systems when the
device is only intermittently connected to a network, or synced regularly at the end
of the day. However, it is not just mobile applications that can benefit from SQL
Server CE, it can be implemented on notebooks and tablets, running full blown Vista,
for richer versions of client software.
Beckhoff Embedded PC Controllers running Windows CE or Embedded can use SQL Server CE as a local data store.
Steps:
Step 1. Install the correct / latest .CAB installation file.
For more information about SQL Server Compact Edition:
http://www.microsoft.com/sqlserver/2008/en/us/compact.aspx
At the time of this article the latest version is 3.5 SP1. Follow the links to the download page for this component. You will be faced with several choices, ultimately, you want: Microsoft SQL Server Compact 3.5 Service Pack 1 for Windows Mobile
Beckhoff Remote Display Utility
ftp://ftp.beckhoff.com/Software/embPC-Control/CE/Solutions/RemoteDisplay
3.5 Compact Framework Installation
c:\Program Files\Microsoft.NET\SDK\CompactFramework\v3.5\WindowsCE\
CX1020 is a x86 processor, so use: NETCFv35.wce.x86.cab
SQL Server Compact Edition 3.5 SP1 Installation
c:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Devices\wce500\x86\
SQL Server Core: sqlce.wce5.x86.CAB
SQL Replication Components: sqlce.repl.wce5.x86.CAB
SQL Development Tool: sqlce.dev.ENU.wce5.x86.CAB
