Re: Updating a CDB File

Tech-Archive recommends: Fix windows errors by optimizing your registry

Arun,

Thank you very much for your help!

> eVC4 is a good choice, You may get samples with SQL Server CE 2000
> usually when installed will be in directory C:\Program Files\Microsoft
> SQL Server CE 2.0\Samples\eVC
>
> MSDE
> http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en

Using the above link, I downloaded and unpacked MSDE. But when I run the
installer, I get this error message:

A strong SA password is required for security reasons. Please use SAPWD
switch to supply the same. Refer to readme for more details. Setup will now
exit.

OK, so I looked in the readme file. It explained that I need to set an SA
password, whatever that is, and that I should go to:

http://support.microsoft.com/?kbid=322336#3

for instructions. I went to that page and found the section called "How to
Change Your SA Password". The first step is to enter this command at a DOS
prompt:

osql -U sa

when I do so, I am told that osql is an unrecognized command. I did a search
on my computer, and there are no files called osql. Could Microsoft possibly
make this any more difficult? Any idea what I should do?

> SQL Server CE
> http://www.microsoft.com/sql/ce/downloads/ce20.asp

I downloaded this and installed it. I then opened the northwindoledb
example. After adding the required Include paths as described in the
documentation, it compiled OK. But even after adding the Link library path,
which I believe should be:

C:\Program Files\Windows CE Tools\wce300\Pocket PC 2002\dataaccess31\lib\arm

I still get 16 errors during the link process:

Employees.obj : error LNK2019: unresolved external symbol CoInitializeEx
referenced in function "public: __cdecl Employees::Employees(int *)"
(??0Employees@@QAA@PAH@Z)
Employees.obj : error LNK2019: unresolved external symbol CoUninitialize
referenced in function "public: virtual __cdecl Employees::~Employees(void)"
(??1Employees@@UAA@XZ)
Employees.obj : error LNK2019: unresolved external symbol VariantClear
referenced in function "private: long __cdecl
Employees::CreateDatabase(void)" (?CreateDatabase@Employees@@AAAJXZ)
Employees.obj : error LNK2001: unresolved external symbol IID_IUnknown
Employees.obj : error LNK2019: unresolved external symbol SysAllocString
referenced in function "private: long __cdecl
Employees::CreateDatabase(void)" (?CreateDatabase@Employees@@AAAJXZ)
Employees.obj : error LNK2019: unresolved external symbol CoCreateInstance
referenced in function "private: long __cdecl
Employees::CreateDatabase(void)" (?CreateDatabase@Employees@@AAAJXZ)
Employees.obj : error LNK2019: unresolved external symbol VariantInit
referenced in function "private: long __cdecl
Employees::CreateDatabase(void)" (?CreateDatabase@Employees@@AAAJXZ)
Employees.obj : error LNK2001: unresolved external symbol GUID_NULL
Employees.obj : error LNK2019: unresolved external symbol CoTaskMemFree
referenced in function "private: long __cdecl
Employees::InsertEmployeeInfo(void)" (?InsertEmployeeInfo@Employees@@AAAJXZ)
Employees.obj : error LNK2001: unresolved external symbol
IID_ISequentialStream
Employees.obj : error LNK2019: unresolved external symbol CoTaskMemAlloc
referenced in function "private: long __cdecl
Employees::InsertEmployeeInfo(void)" (?InsertEmployeeInfo@Employees@@AAAJXZ)
Employees.obj : error LNK2001: unresolved external symbol IID_ILockBytes
NorthwindOleDb.obj : error LNK2019: unresolved external symbol
SHHandleWMSettingChange referenced in function "long __cdecl WndProc(struct
HWND__ *,unsigned int,unsigned int,long)" (?WndProc@@YAJPAUHWND__@@IIJ@Z)
NorthwindOleDb.obj : error LNK2019: unresolved external symbol
SHHandleWMActivate referenced in function "long __cdecl WndProc(struct HWND__
*,unsigned int,unsigned int,long)" (?WndProc@@YAJPAUHWND__@@IIJ@Z)
NorthwindOleDb.obj : error LNK2019: unresolved external symbol
SHCreateMenuBar referenced in function "struct HWND__ * __cdecl
CreateRpCommandBar(struct HWND__ *)"
(?CreateRpCommandBar@@YAPAUHWND__@@PAU1@@Z)

Any idea what I can do to to fix this? Thanks.

E.D.
.