Database Interface Examples: • Access a database file at the fixed location \Harddisk\MyDatabase.sdf : Provider=SQLCE; Data Source=\Harddisk\MyDatabase.sdf The exact path depends on how your device's non-volatile memory is organized. Please consult the manufacturer's documentation. • Access a database file at the location specified by the String tag DatabaseFile : Provider=SQLCE; Data Source={DatabaseFile} The curly brackets ( {} ) indicate that it's a tag reference. Please keep in mind that SQL CE is only intended for lightweight databases and simple transactions. It cannot efficiently handle large amounts of data, such as the Alarm and Event histories.
In those cases, we recommend that you either use the Proprietary history format or use a more powerful relational database like the full version of Microsoft SQL Server. If you must use SQL CE, then we recommend that you use it only as a Secondary database with the Store and Forward option selected. For more information, see Configuring the Alarm and Event History databases . Caution: When using a Database worksheet or the DB/ERP functions to access a SQL CE database, remember… • Column/field names must match exactly or the database commands will fail; and • IWS data types will be converted into possibly unexpected SQL data types. The following table shows how they're converted:
INSTALLING SQL SERVER ON A WINDOWS EMBEDDED DEVICE Microsoft SQL Server is not included by the manufacturer on most Windows Embedded and Windows Mobile devices, so if your IWS project requires SQL Server, then you may need to download and install it on the device yourself. Before you proceed, check the device manufacturer's documentation to see if the device includes Microsoft SQL Server. If it does, then you should not need to install the software again unless you have problems with it. If it does not, then at least verify the device meets the system requirements for running a IWS project and note the device processor.
Because only the device manufacturer can permanently "install" software on the device using Platform Builder, what you will actually do is copy CAB files to the device's non-volatile memory and then configure the device to load those files every time it starts up. Note: At the time of this writing, the latest stable version of SQL Server is Microsoft SQL Server Compact Edition 3.5 Service Pack 2 . 1. On your desktop, download Microsoft SQL Server Compact Edition from the following website:
http:// www.microsoft.com/sqlserver/en/us/editions/compact.aspx InduSoft Web Studio Page 421 Version Connection String SQL CE 3.0 Provider=SQL CE3.0; Data _ Source=database path _ SQL CE 3.5 Provider=SQL CE3.5; Data _ Source=database path _ Note: The database interface was fully tested with these versions of SQL CE. However, other versions might also be supported; please contact Customer Support for more information. IWS SQL CE Boolean int Integer int Real real String nvarchar