sql replication

I use windows xp service pack 2.
The service http://magna/SQLServerCE/sscesa20.dll is ok.

SqlCeReplication repl = null;

try
{
// Set the Replication object
repl = new SqlCeReplication();
repl.InternetUrl = //"http://magna/SQLServerCE/sscesa20.dll";
InternetLogin = "";
repl.InternetPassword = /"";
repl.Publisher = "magna";
repl.PublisherDatabase = "pubs";
repl.PublisherLogin = "pubs";
repl.PublisherPassword = "pubs";
repl.Publication = "pubs_public";
repl.Subscriber = "magna";
repl.SubscriberConnectionString = "Data Source=\\"+txtNomeFile.Text+".sdf";

// Create the Local SSCE Database subscription
repl.AddSubscription(AddOption.CreateDatabase);

// Synchronize to the SQL Server 2000 to populate the Subscription
repl.Synchronize();
}
catch(SqlCeException ex)
{
// Use your own error handling routine to show error information.
System.Console.WriteLine(ex.Message);
MessageBox.Show(ex.Message.ToString());
}
finally
{
// Dispose of the Replication Object
repl.Dispose();
}

the error is ="An incorrect or unsupported HTTP function call was made. [,,,,,]"

thanks in advance bye Alessandro

Answer this question

sql replication

VFP Developer

A couple of things can be done to nail down the casue:

1. put a loop to get all the sqlceerror object and see if there is any hint for this problem.

code may looks like:

foreach ( SqlCeError err in ex.SqlCeErrors )

//look into the native error code and the messages

2. try to setup another virtual directory on other mahines to see if this is an issue with IIS confiuration.

3. you can also set the server side logging level to 3 and check the sscesa20.log ( under the same directory that sscesa20.dll was in ). there may contain some useful info as well )

Please let us know this helps.

Thanks

Yunwen
sql replication

Answer this question

sql replication

Hot Topic

SQL Server

sql replication

sql replication

VFP Developer