SQLCE Replication over GPRS - error 28037

  • Thread starter Thread starter JJ@Google
  • Start date Start date
J

JJ@Google

Hi,

I am developing CF application that uses SQLCE replication. This
works fine when replicating over LAN Internet connection (when in
cradle using ActiveSync), but when I establish GPRS connection and try
it, it fails with error 28037 (request to send data to machine running
IIS failed) occasionally, and the failure rate seems to increase with
increasing amount of data being sent.

Has anyone seen/resolved this issue before? I saw some old posts
suggesting it may be mobile operator specific (Operator is O2), but
not sure if this is the case - anyone found the answer??

Thanks,
John
 
JJ,

how much data are you replicating? which carrier are you using? Merge
over GPRS is really pushing the limits of a 40kpbs connection, but to
help you, here are some pointers:

1. SQL Server 2000 SP3 and QFE 798 provide best merge repl perf
2. you need to defrag your indexes on SQL Server frequently
DBCC SHOWCONTIG(MSMerge_Contents) WITH TABLERESULTS, ALL_INDEXES
3. don't use autogrow on tempdb
4. separate NText and Image types from base tables that are replicated
5. See if you can use the Upload_Only option

you should switch over to newsgroup: microsoft.public.sqlserver.ce - be
happy
to help you there.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
 
Back
Top