How To Use SQL Server CE OLE DB Provider-Specific Properties in eVB

The OLE DB specification allows data providers to implement provider-specific properties. These properties allow the programmer to have access to functionality that is outside the boundaries of the OLE DB specification. The SQL CE Books Online topic SQL Server CE OLE DB Properties Reference describes OLE DB standard and provider-specific properties that are supported by SQL CE OLE DB Provider.

You can use a given property name (for example, DBPROP_INIT_DATASOURCE) in an eVC++ OLE DB application. The description of a property usually documents the name (for example, Data Source) you can use in an eVB ADOCE application. However, for provider-specific properties, you need to add the "SSCE:" prefix to the property description.

Provider-Defined Properties in DBPROPSET_SSCE_DBINIT

Provider-Defined Properties in DBPROPSET_SSCE_SESSION

For additional details on how to use database password and encryption properties, review the SQL CE Books Online topic Creating Secure Databases. You can specify these properties in the connection string as follows: The SSCE:Max Buffer Size property specifies the largest amount of memory, in kilobytes, that SQL Server CE can use before it starts flushing changes to disk. You cannot specify this property in the connection string, or it will report an error. You can set this property after opening the connection, as follows: To implement this in eVC++, review the SQL CE Books Online topic Session Properties.

SQL CE Books Online topic SQL Server CE OLE DB Properties Reference.