SQL Server ce RDA replication configuration-zz

SQL Server ce RDA replication Configuration

What needs be installed before this tutorial

To complete this tutorial I am using the following Configuration:

• Win 2000
• IIS 5 running
• EVB (Embedded Visual Basic)
• SQL Server 2000 Developer Edition (this is what I use on my development desktop PC)
• Web SQL Server 2000 Windows CE Edition
• Lastly but not least your Pocket PC docked or attached via a wireless LAN

In my next tutorial you will be able to use this configuration together withRemotedataaccessObject of SSCE (SQL Server ce edition)'Pull'Data from a remote SQL 2000 database populating a local SSCE table. the actual code to do this is pretty straight forward, however the tasks of setting up both the remote SQL Server and IIS are critical. it's a bit like a house of cards, missing one of these steps will cause the whole thing to fail with some cryptic message which will have you hankering after those DBASE days! Configuration is always a pain but in the immortal words of 'Tony soprano '-"What you gonna do? '

Setting up SQL Server for CE

All the information in this section is contained in the SQL Server help file ("C: \ Program Files \ Microsoft SQL Server ce \ sqlce. CHM ")-I will attempt to workflow it in as simple a fashion as possible-if all else fails you may have to rtfm-" read the manual ".

To get it all hanging together just right we need to configure both SQL Server and Internet Information Server (IIS). What's IIS got to do with all of this you ask incredulously? Communication between the SQL Server (SS) Ce client agent (residing on your Pocket PC) and SS ce Server Manager (residing on the SQL Server) is handled using the HTTP protocol. if you stop to contemplate this it's a very logical if not ingenious approach. SS ce uses IIS to enforce access authentication and permissions in addition to then using HTTP to transmit the data between the wince device and the SQL server.

I wowould encourage you if possible to set up a development environmentWin 2000,IIS 5AndSQL Server 2000All on the same system. I have done this and find that it makes trouble shooting connectivity issues and permissions very easy. I then installedMS ActiveSync,EVBAndSS CEOn this same PC for a completeSS ce test box. Since RDA supports 802.11b I threw in an Orinoco PC card to make the whole thing wireless-but that's a topic for another rainy day.

Grouping ing SQL Server 2000-the shortcut

A shortcut to keep ing the SS access permissions is to use the 'sa 'username to access the remote server from your wince device. make sure you have the SA user name and password at hand. since this is a test box-I'm not worried about Restricting permissions just yet and doing it this way skips some of the potential permissions issues. you can always revisit this section and 'lock it down '.

Now let's configure IIS

We begin by grouping the SS ce server agent which isISAPI DLL.

1) create a directory which IIS will use for the SS ce Server Agent, e.g.
C: \ Inetpub \ wwwroot \ northwind

2) GrabSscesa10.dllFile from it's default install directory:
C: \ Program Files \ Microsoft SQL Server ce \ Server
And copy it to the directory you created in Step 1:
C: \ Inetpub \ wwwroot \ northwind

3) open a command prompt and register the DLL:
Regsvr32 c: \ Inetpub \ wwwroot \ northwind \ sscesa10.dll

4) now open the Internet Services Manager to create the virtual directory:
Right clickThe web site you want to create the new virtual directory in, in most cases using the 'default website' will be the right place.

ChooseNewThenVirtual directory. ClickNext.
ChooseAlias Name, Since we are using the northwind data call it'Northwind'. ClickNextAnd navigate to the directory you created in #1: I. e .'C: \ Inetpub \ wwwroot \ northwind'
InAccess PermissionsList Check'ExecuteAnd disable all the rest.
ClickNextThenFinish.