I have an
VB.NET 2005 /
CE.NET 5 application that has uses SqlClient to
connect to an SQL Server 2005 database to transfer data. I am getting
intermittent problems, occassionally the error message 'General Network
Error - Please check your network documentation' appears. It only happens on
transferring data from the device (SQL Mobile) to the main SQL Server
database, not the other way around. It has been suggested that this is to do
with timeouts, and I have tried adjusting the command timeout value but this
hasn't helped. The only think that I can think is that when I am
transferring data from the device, I am using transactions both on the SQL
Mobile database and the SQL Server 2005 database to ensure that either all
data is transferred and marked as transferred, or none of it...