January 13, 2007 at 1:27 am
i got an error message "An error has occured on the computer running IIS. Try restarting the IIS server."
with error code : 80070057
Minor Error : 28022
here is my code :
private void mitemCreateSubscription_Click(object sender, EventArgs e)
{
SqlCeReplication replSqlMbl = new SqlCeReplication();
try
{
//Internet Properties
replSqlMbl.InternetUrl = strURL;
replSqlMbl.InternetLogin = string.Empty;
replSqlMbl.InternetPassword = string.Empty;
//Publisher Properties
replSqlMbl.Publisher = "Casper2e";
replSqlMbl.PublisherDatabase = "SQLMobile";
replSqlMbl.Publication = "SQLMobile";
replSqlMbl.ExchangeType = ExchangeType.BiDirectional;
//Security Publisher Properties
replSqlMbl.PublisherSecurityMode = SecurityType.NTAuthentication;
replSqlMbl.PublisherLogin = string.Empty;
replSqlMbl.PublisherPassword = string.Empty;
//Subscriber Properties
replSqlMbl.Subscriber = @"Driver#1";
replSqlMbl.SubscriberConnectionString = strConnLocal;
replSqlMbl.AddSubscription(AddOption.CreateDatabase);
}
catch (SqlCeException exSQL)
{
HandleSQLException(exSQL);
}
finally
{
replSqlMbl.Dispose();
}
}
private void mitemSynchronize_Click(object sender, EventArgs e)
{
SqlCeReplication replSqlMbl = new SqlCeReplication();
try
{
//Internet Properties
replSqlMbl.InternetUrl = strURL;
replSqlMbl.InternetLogin = string.Empty;
replSqlMbl.InternetPassword = string.Empty;
//Publisher Properties
replSqlMbl.Publisher = "Casper2e";
replSqlMbl.PublisherDatabase = "SQLMobile";
replSqlMbl.Publication = "SQLMobile";
replSqlMbl.ExchangeType = ExchangeType.BiDirectional;
//Security Publisher Properties
replSqlMbl.PublisherSecurityMode = SecurityType.NTAuthentication;
replSqlMbl.PublisherLogin = string.Empty;
replSqlMbl.PublisherPassword = string.Empty;
//Subscriber Properties
replSqlMbl.Subscriber = "Driver#1";
replSqlMbl.SubscriberConnectionString = strConnLocal;
replSqlMbl.Synchronize();
}
catch (SqlCeException exSQL)
{
HandleSQLException(exSQL);
}
finally
{
replSqlMbl.Dispose();
}
}
the system i use is :
SQL server 2000 Personal Edition
SQL server Mobile 2005
regards,
Aldrich
ps: i've tried the replication using IBuySpyDelivery 2005 that i got from http://www.gotdotnet.com and installed it in my PDA and all works perfectly...
January 16, 2007 at 8:00 am
This was removed by the editor as SPAM
January 30, 2007 at 2:30 pm
I would suggest that you re-check all of your permissions settings to ensure that you have correct access to the IIS server and that the user you are accessing with has permissions for the snapshot folder.
Permissions is always the first place to check with replication (at least for me)
January 30, 2007 at 8:18 pm
Also, check the IIS logs at the time of failure. That may point you to the source of the issue. By default, %systemroot%\system32\logfiles with a separate dir for each web site. Unless the administrator has toggled it differently, log file times are written in GMT, so adjust accordingly.
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply