The OLE DB provider for SQL Server Compact 3.5. reveals the IDBDataSourceAdmin interface through which you can create and manage databases in SQL Server Compact 3.5. To create a new database, you specify the DBPROP_INIT_DATASOURCE property to specify a name for the database.

For more information, see Creating Databases with OLE DB.

Example

The following example shows how to create an encrypted case-sensitive database by using the OLE DB provider for SQL Server Compact. It also demonstrates how to specify a password. To create a standard database, remove the unnecessary DBPROP structures.

// CreateDatabase.cpp : Defines the entry point for the console application.
//
// Include header files
//
#include "stdafx.h"

#include <sqlce_err.h>
#include <sqlce_oledb.h>
#include <sqlce_sync.h>

// Object declarations
HRESULT            hr                   = NOERROR; 
DBPROPSET          dbpropset[2]; 
DBPROP             dbprop[1]; // Property array to initialize the provider.
DBPROP             sscedbprop[3]; // Property array for security and case-sensitivity properties.
INT                i                    = 0;
IDBDataSourceAdmin *pIDBDataSourceAdmin = NULL; 
IUnknown           *pIUnknownSession    = NULL;

int _tmain(int argc, _TCHAR* argv[])
{
   // Create an instance of the OLE DB provider.
   CoInitialize(NULL);
   hr = CoCreateInstance(CLSID_SQLSERVERCE, 0, CLSCTX_INPROC_SERVER, 
      IID_IDBDataSourceAdmin, (void**)& pIDBDataSourceAdmin);

   if(FAILED(hr))
   {
      goto Exit;
   }

   // Initialize property structures.
   VariantInit(&dbprop[0].vValue);
   for (int i = 0; i < sizeof(sscedbprop) / sizeof(sscedbprop[0]); i++)
   {
      VariantInit(&sscedbprop[i].vValue);
   }

   // Specify the property with name of the database.
   dbprop[0].dwPropertyID  = DBPROP_INIT_DATASOURCE;
   dbprop[0].dwOptions   = DBPROPOPTIONS_REQUIRED;
   dbprop[0].vValue.vt   = VT_BSTR;
   dbprop[0].vValue.bstrVal = SysAllocString(L"NewDatabase.sdf"); 

   if(NULL == dbprop[0].vValue.bstrVal)
   {
      hr = E_OUTOFMEMORY;
      goto Exit;
   }

   // Specify the encryption mode. 
   sscedbprop[0].dwPropertyID = DBPROP_SSCE_ENCRYPTIONMODE;
   sscedbprop[0].dwOptions = DBPROPOPTIONS_REQUIRED;
   sscedbprop[0].vValue.vt = VT_I4;
   sscedbprop[0].vValue.intVal = DBPROPVAL_SSCE_EM_PLATFORM_DEFAULT;

   // Specify the strong password.
   sscedbprop[1].dwPropertyID = DBPROP_SSCE_DBPASSWORD;
   sscedbprop[1].dwOptions = DBPROPOPTIONS_REQUIRED;
   sscedbprop[1].vValue.vt = VT_BSTR;
   sscedbprop[1].vValue.bstrVal = SysAllocString(L"<enterStrongPasswordHere>");

   if(NULL == sscedbprop[1].vValue.bstrVal)
   {
     hr = E_OUTOFMEMORY;
     goto Exit;
   }

   // Set the case sensitivity to true.
   sscedbprop[2].dwPropertyID  = DBPROP_SSCE_DBCASESENSITIVE;
   sscedbprop[2].dwOptions   = DBPROPOPTIONS_REQUIRED;
   sscedbprop[2].vValue.vt   = VT_BOOL;
   sscedbprop[2].vValue.boolVal = VARIANT_TRUE;

   // Initialize the property sets.
   dbpropset[0].guidPropertySet = DBPROPSET_DBINIT;
   dbpropset[0].rgProperties  = dbprop;
   dbpropset[0].cProperties  = sizeof(dbprop)/sizeof(dbprop[0]);

   dbpropset[1].guidPropertySet = DBPROPSET_SSCE_DBINIT ;
   dbpropset[1].rgProperties  = sscedbprop;
   dbpropset[1].cProperties  = sizeof(sscedbprop)/sizeof(sscedbprop[0]);

   // Create and initialize the database.
   hr = pIDBDataSourceAdmin->CreateDataSource(sizeof(dbpropset)/sizeof(dbpropset[0]),
   dbpropset, NULL, IID_IUnknown, &pIUnknownSession);
   if(FAILED(hr)) 
   {
     goto Exit;
   }
    // At this point, the new case-sensitive encrypted database is created.

   Exit:
    // Do cleanup tasks here.
      return 0;
}