Replication Failure

[Guest]

Hello All

I'm developing an application that uses SQL CE Replication via RDA using both ActiveSync via an Ethernet Cradle and via a Modem using a Ras Component for CF from intelliprog.com

I successfully push and pull everytime using ActiveSync successfully - even if I do it repeatedly. When I request a pull and push via the modem - after establishing a connection. it works fine THE FIRST TIME. If I then ask for another pull and push - I get the following error found in the SQL CE Books Online

A request to send data to the computer running IIS has failed. For more information, see HRESULT - error code 28037

I I exit the program, then sync via the modem the first time it works, after that it fails with the same error

Obviously, I'm either not releasing resources somewhere - either to the DB or somewhere else

Any ideas?

 

[Chris Craft]

Troubleshooting Microsoft SQL Server 2000 Windows CE Edition Connectivity
Issues
http://msdn.microsoft.com/library/d...y/en-us/dnsqlce/html/sqlce_troubleconnect.asp

I recommend you write an ExceptionManager class and add a ShowSqlCeErrors
method like the following.
SqlCeException really use the inner exceptions, and the innermost one is
often the key.
You'll need the innermost one, to lookup in the above Microsoft whitepaper
to find out what is really going wrong
in your implementation.

I usually have one that will LogSqlCeErrors as well so I can open the text
file on a desktop and see the screens worth of information if need be.

Thanks,
Chris Craft
http://www.cjcraft.com/

#region ShowSqlCeErrors
/// <summary>
/// This method will display all SqlCeException error messages in a series
of MessageBoxes
/// </summary>
/// <remarks name="ShowSqlCeExceptions" classtype="private"
overloaded="no">
/// e.g.:
/// ShowSqlCeErrors();
/// </remarks>
public static void ShowSqlCeErrors(SqlCeException exSql)
{
StringBuilder oSBMsg = new StringBuilder();

int i = 0;

foreach (SqlCeError err in exSql.Errors)
{
i++;

oSBMsg.Append("\n Error # " + i + " of " + exSql.Errors.Count);
oSBMsg.Append("\n Error Code: " + err.HResult);
oSBMsg.Append("\n Message : " + err.Message);
oSBMsg.Append("\n Minor Err.: " + err.NativeError);
oSBMsg.Append("\n Source : " + err.Source);

for (int j = 0; j < err.NumericErrorParameters.Length; j++)
{
if (err.NumericErrorParameters[j] != 0)
{
oSBMsg.Append("\n Numeric Parameter: " +
err.NumericErrorParameters[j]);
}
}

for (int k = 0; k < err.ErrorParameters.Length; k++)
{
if (err.ErrorParameters[k] != String.Empty)
{
oSBMsg.Append("\n Error Parameter : " + err.ErrorParameters[k]);
}
}
MessageBox.Show(oSBMsg.ToString(), "SQL CE Exception",
MessageBoxButtons.OK,
MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1);
oSBMsg.Remove(0, oSBMsg.Length);
//oSBMsg.Append("\n\n");
}
//MessageBox.Show(oSBMsg.ToString());
}
#endregion ShowSqlCeErrors

Hello All:

I'm developing an application that uses SQL CE Replication via RDA using

both ActiveSync via an Ethernet Cradle and via a Modem using a Ras Component
for CF from intelliprog.com.

I successfully push and pull everytime using ActiveSync successfully -

even if I do it repeatedly. When I request a pull and push via the modem -
after establishing a connection. it works fine THE FIRST TIME. If I then ask
for another pull and push - I get the following error found in the SQL CE
Books Online:

A request to send data to the computer running IIS has failed. For more

information, see HRESULT - error code 28037.

I I exit the program, then sync via the modem the first time it works,

after that it fails with the same error.