SQLCE 3.5 Connection Strings
SQLCE 3.5 Connection Strings
Connection String Key Values
Key |
Description/Notes |
Valid Values |
Data Source |
Full path to the .SDF file that will be used.
|
Valid Path to file. |
Password
|
Only required if the SQLCE file is password protected.
|
String value. Leave blank if no password required.
|
Encryption On
|
Check this to encrypt file being created as part of an extract or export.
|
Checked = true Unchecked = false
|
Encryption Mode
|
Specifies type of encryption to use. EngineDefault is the default. |
EngineDefault PlatformDefault PPC2003Compatibility
|
Max Database Size (MB) |
Default is 128 megabytes. Increase this value if database is to contain a large amount of data. This number will have to be increased if application fails to open a file because of space limitations. |
Number.
|
Max Buffer Size (KB) |
Default is 640KB.
|
Number. |
Max Temp File Size (MB) |
Default is 128 MB
|
Number. |