SqlCeReplication property values for replicating a SQL Server db via IIS using VS.NET 2003 -

SqlCeReplication property values for replicating a SQL Server db via IIS using VS.NET 2003 -

Post by Hazzar » Fri, 03 Oct 2003 05:12:53


in order to create the database for my PPC, all of the following have to be
correct for the replication process to work;

oRpl = new SqlCeReplication();
oRpl.Publisher = "";
oRpl.PublisherLogin = "";
oRpl.PublisherPassword = "";
oRpl.InternetUrl = "http://PPC_db_shuttle/sscesa20.dll";
oRpl.InternetLogin = "";
oRpl.InternetPassword = "";
oRpl.Subscriber = "";
oRpl.Publication = "";
oRpl.PublisherDatabase = ""


is there a "paint by number" kind of explanation for each of the properties
above? SQLServerCE online help isn't very helpful. Like this;
"The PublisherLogin property specifies the login name used when connecting
to the Publisher."
O.K?? !!!
or
"The InternetPassword property specifies the MicrosoftInternet Information
Services (IIS) password used when connecting to the SQL Server CE Server
Agent."
and where do I find this?? !!

A picture would be so so helpful for each one of these properties eg. a
screenshot from Enterprise Manager or IIS as appropriate.
That would be HUGE ly helpful.
I have read some very helpful knowledgebases and explanations but none that
have really helped me on my WinXP Pro dev machine.

I "think" I can guess where to get Publisher and Subscriber ....
and then my confidence drops off sharply after that;

thank you,
-Greg

ps. I posted this previously in the sqlserverce newsgroup but i was given
info that was usefull, but info I already had which gave instructions for
win2k and RDA, and general security concepts, but not specifically for this
replication process.
 
 
 

SqlCeReplication property values for replicating a SQL Server db via IIS using VS.NET 2003 -

Post by Renaud Lan » Fri, 03 Oct 2003 21:07:32

PublisherLogin is the Login used for connecting to the database (Used
only for SQLAuthentication. Not used for NTAuthentication.

InternetLogin is the login you use when accessing the InternetUrl.
Generally, it's empty for anonymous web site. The best way to know if
you need one is by typing the Url in IE and see if you can access the
site (InternetUrl). If IE asks for login/password, then it's not set
to anonymous logon. Else check the web site properties in IISand see
if the authentication is set to anonymous (if so, it'll then use the
IUSR_<servername> username to connect).

 
 
 

SqlCeReplication property values for replicating a SQL Server db via IIS using VS.NET 2003 -

Post by Hazzar » Sat, 04 Oct 2003 22:24:16

Thank you very much Renaud.
I appreciate that information.
-Greg




be
properties
connecting
Information >>>>Services (IIS) password used when connecting to the SQL Server CE Server >>>>Agent." >>>>and where do I find this?? !! >>>> >>>>A picture would be so so helpful for each one of these properties eg. a >>>>screenshot from Enterprise Manager or IIS as appropriate. >>>>That would be HUGE ly helpful. >>>>I have read some very helpful knowledgebases and explanations but none
that >>>>have really helped me on my WinXP Pro dev machine. >>>> >>>>I "think" I can guess where to get Publisher and Subscriber .... >>>>and then my confidence drops off sharply after that; >>>> >>>>thank you, >>>>-Greg >>>> >>>>ps. I posted this previously in the sqlserverce newsgroup but i was given >>>>info that was usefull, but info I already had which gave instructions for >>>>win2k and RDA, and general security concepts, but not specifically for
this >>>>replication process. >>>> >>
 
 
 

SqlCeReplication property values for replicating a SQL Server db via IIS using VS.NET 2003 -

Post by Hazzar » Sun, 19 Oct 2003 03:26:45

I finally saw "Synchronization complete" on my pocket pc and the northwind
db fully replicated and available to the app.
Thank you kindly for your assistance.
-Greg Hazzard






to
Server >>>>>>Agent." >>>>>>and where do I find this?? !! >>>>>> >>>>>>A picture would be so so helpful for each one of these properties eg. a >>>>>>screenshot from Enterprise Manager or IIS as appropriate. >>>>>>That would be HUGE ly helpful. >>>>>>I have read some very helpful knowledgebases and explanations but none >> that >>>>>>have really helped me on my WinXP Pro dev machine. >>>>>> >>>>>>I "think" I can guess where to get Publisher and Subscriber .... >>>>>>and then my confidence drops off sharply after that; >>>>>> >>>>>>thank you, >>>>>>-Greg >>>>>> >>>>>>ps. I posted this previously in the sqlserverce newsgroup but i was
given >>>>>>info that was usefull, but info I already had which gave instructions
for >>>>>>win2k and RDA, and general security concepts, but not specifically for >> this >>>>>>replication process. >>>>>> >>>> >> >>