Creating Databases with OLE DB

The OLE DB provider for SQL Server 2005 Compact Edition (SQL Server Compact Edition) reveals the IDBDataSourceAdmin interface through which you can create and manage databases in SQL Server Compact Edition.

Creating a Database

To create a new database, you must specify the DBPROP_INIT_DATASOURCE property to specify a name for the database. For security reasons, the OLE DB provider for SQL Server Compact Edition does not support deleting databases by using IDBDataSourceAdmin::DestroyDataSource. If you want to delete a database and you have access to the file system on the computer, you can delete the database files that are no longer needed.

Securing Databases

For improved security, SQL Server Compact Edition supports creating both password-protected and encrypted databases. Encrypted databases must also be password-protected. Data in a password-protected or encrypted database can be accessed by SQL Server Compact Edition only after the correct password has been provided.

To create an encrypted database by using the OLE DB provider for SQL Server Compact Edition, you must pass the provider-specific property DBPROP_SSCE_ENCRYPTDATABASE as VARIANT_TRUE and specify a password by using the provider-specific property DBPROP_SSCE_DBPASSWORD. The following table summarizes the properties that must be specified to create each type of database.

For an existing database, these properties can be changed when the database is compacted. For more information, see CompactDatabase Method (SQL Server Compact Edition).

Examples

For an example of creating a database with the OLE DB provider for SQL Server Compact Edition, see How to: Create a Database by Using OLE DB (Programmatically).