Page 1
Page 2
Page 3
Page 4
Page 5
Page 6
Page 7
Appendix E: Replication Object Properties
The reference for the following information
is located in "SQL Server CE Books Online" under the
topic "Building Applications\Programmer's Reference\Replication
Object"
In general, Internet properties pertain to
the web server computer that contains the SQL Server CE Server
Agent (SSCESA10.dll). Publisher properties deal with the SQL Server
computer that contains the publication. Distributor properties
are concerned with the SQL Server computer where the snapshots
are stored. In our model, these all reside on the same laptop
computer. The Internet properties used the IP address and the
others use the laptop name.
InternetURL
Specifies the URL used to connect to the SQL Server CE Server
Agent ISAPI DLL.
The fully qualified path including the IP Address, virtual directory,
and sscesa10.dll.
http://10.10.10.46/ContactManager/sscesa10.dll
InternetLogin
Specifies the login name used when connecting to the SQL Server
CE Server Agent ISAPI DLL.
We did not use a login name.
InternetPassword
Specifies the password used when connecting to the SQL Server
CE Server Agent.
We did not use a password.
InternetProxyServer
Specifies the proxy server to use when accessing the HTTP resource
specified in the InternetURL property.
Include the port number.
http://10.10.10.46:80
Publisher
SQL Server computer that contains the publication.
JBURDETT_LT
PublisherDatabase
Specifies the name of the publication database.
ContactManager
Publication
Specifies the name of a publication that has been enabled for
anonymous merge subscriptions.
ContactManager
PublisherSecurityMode
Specifies the security mode used when connecting to the Publisher.
DB_AUTHENTICATION
PublisherNetwork
Specifies the network protocol used when the SQL Server CE Server
Agent communicates with the Publisher.
DEFAULT_NETWORK
PublisherLogin
Specifies the login name used when connecting to the Publisher.
We used the default SQL password which is not recommended to keep.
PublisherPassword
Specifies the login password used when connecting to the Publisher.
We used the default empty string.
SubscriberConnectionString
Specifies the OLE DB connection string for the SQL Server CE database
on the Windows CE device.
We used the path to the database.
"data source=\Program Files\ContactManager\database\ ContactManager.sdf"
Subscriber
Specifies the name of the Subscriber.
We used PPC_ ContactManager.
Distributor
SQL Server computer where the snapshots are stored and where replication
history and statistics are logged.
JBURDETT_LT
DistributorLogin
Specifies the login name used when connecting to the Distributor.
We used the default SQL password which is not recommended to keep.
DistributorPassword
Specifies the login password used when connecting to the Distributor.
We used the default empty string.
DistributorSecurityMode
Specifies the security mode used when connecting to the Distributor.
DB_AUTHENTICATION
Appendix F: modActiveSync (PocketPC)
' This module contains the code to start ActiveSync
programmatically.
' Much of the API code was copied from Microsoft (KB Article Q265793).
Download
the modActiveSync.bas code
Appendix G: Stored Procedures
spGetConflictSummary
CREATE PROCEDURE [dbo].spGetConflictSummary
AS
/* Contact Table */
SELECT create_time AS 'DATE',
'CONTACT' AS 'TABLE',
reason_text AS 'DESC',
ContactID as 'GUID'
FROM conflict_ContactManager_Contact
RETURN
GO
spGetContactByContactID
CREATE PROCEDURE [dbo].spGetContactByContactID
@ContactID UNIQUEIDENTIFIER
AS
SELECT
ContactID,
FirstName,
MiddleName,
LastName,
Notes,
'AS ORIGIN_DATASOURCE
' /* Used to comply with conflict recordset */
FROM
Contact
WHERE
ContactID = @ContactID
RETURN
GO
Previous Page
Next Page