1 HRESULT hr = NOERROR;
2 DBPROPSET dbpropset[2];
3 DBPROP dbprop[1]; // Property array to initialize the provider.
4 DBPROP sscedbprop[2]; // Property array for SSCE security properties
5 INT i = 0;
6 IDBDataSourceAdmin *pIDBDataSourceAdmin = NULL;
7 IUnknown *pIUnknownSession = NULL;
8 IDBInitialize *pIDBInitialize = NULL;
9 // Create an instance of the OLE DB provider.
10 hr = CoCreateInstance(CLSID_SQLSERVERCE_2_0, 0, CLSCTX_INPROC_SERVER,
11 IID_IDBInitialize, (void**)&pIDBInitialize);
12 if(FAILED(hr))
13 {
14 RETAILMSG(1,(TEXT("1==CoCreateInstance: %d /r/n"),GetLastError()));
15 goto CleanExit;
16 }
17 // Initialize property structures.
18 VariantInit(&dbprop[0].vValue);
19 for (i = 0; i < sizeof(sscedbprop) / sizeof(sscedbprop[0]); i++)
20 {
21 VariantInit(&sscedbprop[i].vValue);
22 }
23 // Leo:To create a new database, you must specify the DBPROP_INIT_DATASOURCE property to
24 // specify a name for the database.
25 dbprop[0].dwPropertyID = DBPROP_INIT_DATASOURCE;
26 dbprop[0].dwOptions = DBPROPOPTIONS_REQUIRED;
27 dbprop[0].vValue.vt = VT_BSTR;
28 dbprop[0].vValue.bstrVal = SysAllocString(L"Encrypted.sdf");
29 if(NULL == dbprop[0].vValue.bstrVal)
30 {
31 hr = E_OUTOFMEMORY;
32 goto CleanExit;
33 }
34 // Specify the property for encryption.
35 sscedbprop[0].dwPropertyID = DBPROP_SSCE_ENCRYPTDATABASE;
36 sscedbprop[0].dwOptions = DBPROPOPTIONS_REQUIRED;
37 sscedbprop[0].vValue.vt = VT_BOOL;
38 sscedbprop[0].vValue.boolVal = VARIANT_TRUE;
39 // Specify the password.
40 sscedbprop[1].dwPropertyID = DBPROP_SSCE_DBPASSWORD;
41 sscedbprop[1].dwOptions = DBPROPOPTIONS_REQUIRED;
42 sscedbprop[1].vValue.vt = VT_BSTR;
43 sscedbprop[1].vValue.bstrVal = SysAllocString(L"123456"); //密码
44 if(NULL == sscedbprop[1].vValue.bstrVal)
45 {
46 hr = E_OUTOFMEMORY;
47 goto CleanExit;
48 }
49 // Initialize the property sets.
50 dbpropset[0].guidPropertySet = DBPROPSET_DBINIT;
51 dbpropset[0].rgProperties = dbprop;
52 dbpropset[0].cProperties = sizeof(dbprop)/sizeof(dbprop[0]);
53 dbpropset[1].guidPropertySet = DBPROPSET_SSCE_DBINIT ;
54 dbpropset[1].rgProperties = sscedbprop;
55 dbpropset[1].cProperties = sizeof(sscedbprop)/sizeof(sscedbprop[0]);
56 hr = pIDBInitialize->QueryInterface(IID_IDBDataSourceAdmin,(void **)&pIDBDataSourceAdmin);
57 if(FAILED(hr))
58 {
59 RETAILMSG(1,(TEXT("1==pIDBInitialize->QueryInterface: %d /r/n"),hr));
60 goto CleanExit;
61 }
62 // Create and initialize the database.
63 hr = pIDBDataSourceAdmin->CreateDataSource(sizeof(dbpropset)/sizeof(dbpropset[0]),
64 dbpropset, NULL, IID_IUnknown, &pIUnknownSession);
65 if(FAILED(hr))
66 {
67 RETAILMSG(1,(TEXT("1==pIDBDataSourceAdmin->CreateDataSource: %d /r/n"),hr));
68 goto CleanExit;
69 }
70 // At this point, the new encrypted database is created.
71 leanExit:
72 VariantClear(&dbprop[0].vValue);
73 SysFreeString(dbprop[0].vValue.bstrVal);
74 for(i = 0;i < sizeof(sscedbprop) / sizeof(sscedbprop[0]);i++)
75 {
76 VariantClear(&sscedbprop[i].vValue);
77 }
78 // Do cleanup tasks here.
79 if(NULL != pIDBDataSourceAdmin)
80 {
81 pIDBDataSourceAdmin->Release();
82 pIDBDataSourceAdmin = NULL;
83 }
84 if(NULL != pIDBInitialize)
85 {
86 pIDBInitialize->Release();
87 pIDBInitialize = NULL;
88 }
89 if(NULL != pIUnknownSession)
90 {
91 pIUnknownSession->Release();
92 pIUnknownSession = NULL;
93 }
94 return;
