压缩数据库sdf文件

[linweishang]

using System.Data.SqlServerCe
我在EVC下使用using System.Data.SqlServerCe和SqlCeEngine,
编译提示：undeclared identifier!
请问该如何解决？
在EVC下是如何：压缩数据库sdf文件的！
感激不尽，零表涕蔹！

[shmily1280]

HRESULT CDlgDataBaseRepair::CompactDataBase()
{
CoInitializeEx(NULL, COINIT_MULTITHREADED);
HRESULT hr = NOERROR; // Error code reporting
DBPROPSET dbpropset[1]; // Property Set used to initialize provider
DBPROP dbprop[1]; // property array used in property set to initialize provider

// Provider Interfaces
IDBProperties * pIDBProperties = NULL;
IDBCreateSession * pIDBCreateSession = NULL;
ISSCECompact *pISSCECompact = NULL;
IDBSchemaRowset * pIDBSchemaRowset = NULL;

VariantInit(&dbprop[0].vValue);

// Create an instance of the OLE DB Provider for SSCE 1.0
hr = CoCreateInstance(CLSID_SQLSERVERCE_2_0, 0, CLSCTX_INPROC_SERVER, IID_IDBProperties, (void**) &pIDBProperties);
if(FAILED(hr))
{
//wcerr << L"Failed to instantiate OLE DB Provider for SSCE10" << endl;
goto Exit;
}

// Initialize Property with name of database
dbprop[0].dwPropertyID = DBPROP_INIT_DATASOURCE;
dbprop[0].dwOptions = DBPROPOPTIONS_REQUIRED;
dbprop[0].vValue.vt = VT_BSTR;
dbprop[0].vValue.bstrVal = SysAllocString(L"\\硬盘\\1.sdf");
if(NULL == dbprop[0].vValue.bstrVal)
{
hr = E_OUTOFMEMORY;
goto Exit;
}

// Initialize property set
dbpropset[0].guidPropertySet = DBPROPSET_DBINIT;
dbpropset[0].rgProperties = dbprop;
dbpropset[0].cProperties = 1;

// Set properties into the provider's DSO object
hr = pIDBProperties->SetProperties(1, dbpropset);
if(FAILED(hr))
{
//wcerr << L"Failed to set properties." << endl;
goto Exit;
}

// Get IDBCreateSession interface
hr = pIDBProperties->QueryInterface(IID_ISSCECompact, (void **) &pISSCECompact);
if(FAILED(hr))
{
goto Exit;
}
::DeleteFile(L"\\硬盘\\temp.sdf");
SysFreeString(dbprop[0].vValue.bstrVal);
dbprop[0].vValue.bstrVal = SysAllocString(L"\\硬盘\\temp.sdf");
if(NULL == dbprop[0].vValue.bstrVal)
{
hr = E_OUTOFMEMORY;
goto Exit;
}

hr = pISSCECompact->Compact(1, dbpropset);
if(FAILED(hr))
{
goto Exit;
}
// m_bNotNeedRepair = TRUE;
::CopyFile(L"\\硬盘\\temp.sdf",L"\\硬盘\\1.sdf",FALSE);
::CopyFile(L"\\硬盘\\temp.sdf",L"\\硬盘\\DataBaseBak\\1.sdf",FALSE);

Exit:

VariantClear(&dbprop[0].vValue);

// Release interfaces
if(NULL != pISSCECompact)
{
pISSCECompact->Release();
}
if(NULL != pIDBSchemaRowset)
{
pIDBSchemaRowset->Release();
}
if(NULL != pIDBCreateSession)
{
pIDBCreateSession->Release();
}
if(NULL != pIDBProperties)
{
pIDBProperties->Release();
}
// Uninitialize the environment
::CoUninitialize();

return hr;
}

程序是这么写的,这只是我程序里的一个方法.需要一些头文件,最好先自己找找吧.因为要出差了,没办法给你更多东西了

[linweishang]

#include "D:\Program Files\Microsoft SQL Server CE 2.0\Inc\SSCEOLEDB.H"
#include <oledb.h>
#include "d:\JetVC\jetoledb.h"
#include "d:\JetVC\msjetoledb.h"
#include "stdafx.h"

#include "MySQLCETest.h"
#include "MySQLCETestDlg.h"
#include "atldbcli.h"
出错信息如下：
D:\Program Files\Windows CE Tools\wce420\POCKET PC 2003\Include\emulator\msdasc.h(242) : error C2061: syntax error : identifier 'DBSOURCETYPE'
D:\Program Files\Windows CE Tools\wce420\POCKET PC 2003\Include\emulator\msdasc.h(334) : error C2061: syntax error : identifier 'DBSOURCETYPE'
///DBSOURCETYPE在"oledb.h"已经定义了！，为什么呢说没有定义呢！！？？
D:\Program Files\Windows CE Tools\wce420\POCKET PC 2003\atl\include\atldbcli.h(48) : error C2146: syntax error : missing ';' before identifier '_GetOleDBType'
D:\Program Files\Windows CE Tools\wce420\POCKET PC 2003\atl\include\atldbcli.h(48) : error C2433: 'DBTYPE' : 'inline' not permitted on data declarations
D:\Program Files\Windows CE Tools\wce420\POCKET PC 2003\atl\include\atldbcli.h(48) : error C2501: 'DBTYPE' : missing storage-class or type specifiers
D:\Program Files\Windows CE Tools\wce420\POCKET PC 2003\atl\include\atldbcli.h(48) : fatal error C1004: unexpected end of file found
Error executing cl.exe.
///'_GetOleDBType'这么没有找到啊？？
老哥我都加了还是不行啊，你啥时候回来啊？救我啊！

[linweishang]

#include "D:\Program Files\Microsoft SQL Server CE 2.0\Inc\SSCEOLEDB.H"
#include <oledb.h>
#include "d:\JetVC\jetoledb.h"
#include "d:\JetVC\msjetoledb.h"
至于把这些头文件放置在#include "stdafx.h"之外，是由于有人说此不是基于MFC类的，所以应该放置在#include "stdafx.h"外面。
对于不加上面的头文件也是7个错误。
而#include "atldbcli.h"里面已经加了“oledb.h”,应该不用加也可以了。郁闷了，明明olddb.h已经定义了TYPEDEF WORD DBSOURCETYPE;为什么说identifier 'DBSOURCETYPE'呢？？？？

[linweishang]

除了oledb.lib之外其它的Coredll.lib,ole32.lib,oleaut32.lib,Uuid.lib,都能够在D:\Program Files\Windows CE Tools\wce420\POCKET PC 2003\Lib\emulator下找到！oledbtype类型未能找到。
我开发环境是EVC4.0，SDK是PPC2003。
想不好了！

[shmily1280]

#include <oledb.h>
#include <oledberr.h>

#include <coguid.h>

// SSCE Files:
//
#include <ssceoledb.h>

所需要要的头文件~~

#include <COMDEF.H> 这个东西忘记了需不需要

[shmily1280]

对了,上面4个是放在StdAfx.h文件中的
下面那个是放在压缩方法的类.H文件中的

[liaoxiuhua]

为什么执行完这个方法，数据库一点也没效果没有