DesktopSqlCe Connection properties
The SqlCeConnection object supports a limited set of connection string properties that are described here as well as the limitations of the parser.
Availabe properties
The following table describes the supported connection properties of the SqlCeConnection class:
|
Property
|
Description
|
|
data source
|
Specifies the database file path and name on the device. The .sdf file extension is not assumed as default.
|
|
ssce:temp file directory
|
Specifies the directory where the SQL CE / Mobile / Everywhere engine will store temporary files. When using databases in flash media it is recommended that the temporary file directory be specified also in the flash card.
|
|
ssce:database password
|
Specifies the database password.
|
|
database password
|
Specifies the database password.
|
|
password
|
Specifies the database password.
|
|
ssce:encrypt database
|
When set to true the database file will be encrypted.
|
|
dssce:ip
|
Specifies the target device IP address when using TCP/IP connectivity.
|
|
dssce:port
|
Specifies the target device IP port when using TCP/IP connectivity. By default the port number is 5691.
|
|
dssce:local
|
When set to true tells the code to open a desktop SQL Everywhere database. The data source property and ssce:temp file directory must be valid desktop filenames.
|
Parser limitations
When parsing the connection string for properties the SqlCeConnection code does not recognize white space. Make sure you enter your properties as in the following sample:
"Data Source=\CF Card\db\V3\Northwind.sdf; dssce:database password=pwd"
Spaces between the end of a property and the beginning of the next are skipped, but you cannot enter more white space than the property string expects.
|
