SQLCE 4.0 Connection Strings

image\SQLCEConnectionStrings.gif

 

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

 

Max Database Size (MB)

Default is 256 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 4096 KB.

 

Number.

Max Temp File Size (MB)

Default is 256 MB

 

Number.