CodeProject: Install and Configure SQL Server for SQLCE replication. Free source code and programming help

Announcements

Monthly Competition

Articles

Desktop Development

Web Development

Enterprise Systems

Content Management Server

Microsoft BizTalk Server

SQL Reporting Services

Platforms, Frameworks & Libraries

Windows Communication Foundation

Windows Presentation Foundation

Windows Workflow Foundation

Cryptography & Security

Threads, Processes & IPC

Development Lifecycle

Debug Tips

Design and Architecture

Uncategorised Technical Blogs

Services

Code-signing Certificates

Job Board

CodeProject VS2008 Addin

Feature Zones

Product Showcase

WhitePapers / Webcasts

IBM DeveloperWorks

ASP.NET Web Hosting

Advanced Search

Report

Discuss

11 votes for this article.

Popularity: 3.85 Rating: 3.70 out of 5

Introduction

Let me start by saying that I'm not a SQL guru, I'm not a DBA, I'm a lowly application programmer who just happens to (begrudgingly) need to use SQL server. I thought I was fairly adept and figuring out weird combinations of software until I tried to install SQL Server CE and set it up to replication with my SQL Server on the desktop.

SQLCE and SQL Server, they are supposed to work together, right? They do but there are a few gotchas along the way that you might like to know about. I look forward to hearing other tips or advice on this process.

The instructions

It's pretty simple actually but you have to do it exactly as follows.

Note

SQLCE (Server Tools) will not install without SP1 it will not install with SP3. You must install SQL2k -> SQL2KSP1 --> SQLCE --> SQL2KSP3
SQL Replication will not work if the SQL service is running under the system account. You MUST configure the SQL services to use a DOMAIN account with 'run as service' privilege

Steps

Run SQL 2K Installer.
Change the Instance Name
Do NOT use the System account. It does not work for replication.
The account you use must run as a service
The account must have a password
change the sa password
Install SP1. DO NOT install SP3 yet. SQLCE will not install over SP3
Now Install SQLCE
Now Install SP3

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

About the Author

Garth Tissington

Member

Location:

Canada

Other popular Mobile Development articles:

Writing Your Own GPS Applications: Part 2
In part two of the series, the author of "GPS.NET" teaches developers how to write GPS applications suitable for the real world by mastering GPS precision concepts. Source code includes a working NMEA interpreter and sample high-precision application in C# and VB.NET.
Writing Your Own GPS Applications: Part I
What is it that GPS applications need to be good enough to use for in-car navigation? Also, how does the process of interpreting GPS data actually work? In this three-part series, I will cover both topics and give you the skills you need to write a commercial-grade GPS application.
Learn How to Find GPS Location on Any SmartPhone, and Then Make it Relevant
A step by step tutorial for getting GPS from any SmartPhone, even without GPS built in, and then making location useful.
Pocket 1945 - A C# .NET CF Shooter
An article on Pocket PC game development
iPhone UI in Windows Mobile
It's an interface that works with transparency effects. As a sample I used an interface just like the iPhone one. In this tutorial I am explaining how simple is working with transparency on Windows Mobile.

Article Top

You must Sign In to use this message board.

FAQ
Noise Tolerance Layout Per page

Msgs 1 to 9 of 9 (Total in Forum: 9) (Refresh)

FirstPrevNext

Related SQLCE article

Samuel Allen

19:03 26 May '08

Re: Related SQLCE article

123erich123

0:57 25 Sep '08

SQL Server (CE) 2000 SP4... download here

Christopher Scholten

23:41 15 Jul '05

Strange linking errors

Alex Evans

23:00 2 Oct '04

SQL CE does install over SP3

tetsuo119

10:38 23 Jun '04

please elaborate !!

dharani

17:59 23 Mar '04

dear author
i am a new user on embedded vc++ / SQL Ce. I am yet to find out whether my SQL CE installation is correct or not . To summarise what I did ...
IIS Is already running ....
1) Installed embedded vc++ 4.0
2) Installed pocket PC 2003 SDK
3) Installed SQL Server CE 2.0 ( I think its SP1). My system is XP . I am able to run MFC applications on the emulator . fine.The SQL Server CE installed the folders . D:/program files/ SQL Server CE 2.0 and in that the following folders /Server /Redist /Samples /Inc /Lib etc . In the start menu
I got Start -->prog files-->SQL Server CE --->SQL Server CE connectivty management . I created a virtual folder and the sql server ce agent is (sscesa20.dll) at d:/prog files/SQL Server CE/Server . Ok . But I am trying to connect to SQL Server database from within the emulator and later on with device ( Pocket PC Casio 800 which I have not yet seen ) ...
This is the piece of code I have written the Pocket PC appliation ..
#include "D:\Program Files\Windows CE Tools\wce420\POCKET PC 2003\Include\Emulator\oledb.h"
#include "D:\Program Files\Windows CE Tools\wce420\POCKET PC 2003\Include\Emulator\oledberr.h"
#include "D:\Program Files\Microsoft SQL Server CE 2.0\Inc\ssceoledb2.h"

IDBDataSourceAdmin *pIDBDataSourceAdmin = NULL;

HRESULT hr= NOERROR;
ULONG cProps = 1;
DBPROP rgProps[1];
DBPROPSET PropSet;

// Create the SQL Server CE provider
//
hr = CoCreateInstance(CLSID_SQLSERVERCE_1_0,NULL,CLSCTX_INPROC_SERVER,
IID_IDBDataSourceAdmin,(void**)&pIDBDataSourceAdmin);
//Set the properties

if(SUCCEEDED(hr))
{
AfxMessageBox(_T("done"));
}
else
{
AfxMessageBox(_T("not done"));
}
for (ULONG i = 0; i < cProps; i++ )
{
VariantInit(&rgProps[i].vValue);
rgProps[i].dwOptions = DBPROPOPTIONS_REQUIRED;
rgProps[i].colid = DB_NULLID;
}

rgProps[0].dwPropertyID = DBPROP_INIT_DATASOURCE;
rgProps[0].vValue.vt = VT_BSTR;
rgProps[0].vValue.bstrVal = SysAllocString(OLESTR("\\Northwind.sdf"));

PropSet.rgProperties = rgProps;
PropSet.cProperties = cProps;
PropSet.guidPropertySet = DBPROPSET_DBINIT;

hr = pIDBDataSourceAdmin->CreateDataSource(cProps,&PropSet,NULL,IID_IUnknown,NULL);

if(SUCCEEDED(hr))
{
AfxMessageBox(_T(" done "));
}
else
{
AfxMessageBox(_T("not done"));
}
But the CoCreateInstance() and CreateDataSource () functions both are failing . In fact I have compilation errors and changed the installed ssceoledb.h with another latest sscedoledb.h patch from MS site . Still I could nt find out how to get the functions sucessful . And could u pls tell me how I could acheive the following.
1) The methods and code to access SQL Server database from SQL CE or ADO CE (if u know tell me The diffrence between SQL CE and ADO CE usage..most info availabe from MSDN are large and uncompiled )
2) How to get a set of data from SQL Server database into the emulator or device and then update the data and reload it back to SQL server .
I found that eVB has more sample and support than evC++ .
Thats it...will be very helpful if u could shed some light on this ...
with regards and thanks in advance
dharani babu s

2.33/5 (3 votes)

Re: please elaborate !!