Provider-Specific Properties (OLE DB)
SQL Server 2005 Compact Edition (SQL Server Compact Edition)defines a several provider-specific properties in the DBPROPSET_SSCE_DBINIT and DBPROPSET_SSCE_SESSION property sets.
DBPROPSET_SSCE_DBINIT Property Set
The DBPROPSET_SSCE_DBINIT property set contains the following properties that are specific to the OLE DB provider for SQL Server Compact Edition.
| Property ID | Description |
|---|---|
DBPROP_SSCE_DBPASSWORD |
Type: VT_BSTR Typical R/W: R/W Description: SQL Server Compact Edition OLEDB:Database Password Notes: The password used to open the database. The default is no password. |
DBPROP_SSCE_ENCRYPTDATABASE |
Type: VT_BOOL Typical R/W: R/W Description: SQL Server Compact Edition OLEDB:Encrypt Database Notes: Determines whether a compacted or a newly created database should be encrypted. The default value is false (no encryption). However, if a password is supplied by using DBPROP_SSCE_DBPASSWORD, the database is automatically encrypted. |
DBPROP_SSCE_TEMPFILE_DIRECTORY |
Type: VT_BSTR Typical R/W: R/W Description: SQL Server Compact Edition OLEDB: Temp File Directory Notes: Used to specify the temp file directory. If no temp file directory is specified (the default), the main database is used as the temp database. |
DBPROP_SSCE_TEMPFILE_MAX_SIZE |
The maximum size of the temporary database file in MB. The default value is 128 MB. |
DBPROP_SSCE_DEFAULT_LOCK_ESCALATION |
The number of locks the engine will acquire before attempting escalation from row to table or from page to table. The default value is 100 locks. |
DBPROP_SSCE_AUTO_SHRINK_THRESHOLD |
The percent of free space in the file before autoshrink will start. A value of 100 percent disables autoshrink. The default value is 60 percent. |
DBPROP_SSCE_MAX_DATABASE_SIZE |
The maximum size of the database in MB. The default value is 128 MB. |
DBPROP_SSCE_FLUSH_INTERVAL |
The interval at which committed transactions are flushed to disk, in seconds. When a transaction is committed, it will be flushed to disk later, by default. The flush interval indicates that these transactions should be flushed every n seconds where n is the flush interval. This parameter is ignored if the database is already open and another client has already specified this parameter. The store is always internally flushed when closed. The default value for the flush interval is 10 seconds. |
DBPROP_SSCE_DEFAULT_LOCK_TIMEOUT |
The default number of milliseconds a transaction will wait for a lock. This property can be overridden for an individual transaction using the DBPROP_SSCE_LOCK_TIMEOUT property. The default value is 2000 milliseconds. |
DBPROP_SSCE_MAXBUFFERSIZE |
The largest amount of memory, in kilobytes, that SQL Server Compact Edition can use before it starts flushing changes to disk. The default value is 640 kilobytes. |
DBPROPSET_SSCE_SESSION Property Set
The DBPROPSET_SSCE_SESSION property set contains the following property that is specific to the OLE DB provider for SQL Server Compact Edition.
| Property ID | Description |
|---|---|
DBPROP_SSCE_LOCK_TIMEOUT |
Number of milliseconds a transaction will wait for a lock. The default value is 2000 milliseconds. |
DBPROP_SSCE_LOCK_ESCALATION |
Number of locks the engine will acquire before trying escalation from row to page or from page to table. The default value is 100 locks. |
DBPROP_SSCE_TRANSACTION_COMMIT_MODE |
The default value is DBPROPVAL_SSCE_TCM_DEFAULT (deferred flush). |
DBPROPSET_SSCE_COLUMN Property Set
The DBPROPSET_SSCE_COLUMN property set contains the following properties that are specific to the OLE DB provider for SQL Server Compact Edition.
| Property ID | Description |
|---|---|
DBPROP_SSCE_COL_ROWGUID |
|
DBPROPSET_SSCE_ROWSET Property Set
The DBPROPSET_SSCE_ROWSET property set contains the following property that is specific to the OLE DB provider for SQL Server Compact Edition.
| Property ID | Description |
|---|---|
DBPROP_SSCE_LOCK_HINT |
The default value is DBPROPVAL_SSCE_LH_NOLOCK (no lock is used). |