Can't replicate with cellular modem.

Using Merge replication.
Publisher is Sql Server 2000 SP4, subscribers are laptops using MSDE SP4.
Using anonymous subscribers that use the SQLMerge object to invoke
replication. Our laptops are everywhere. Some use highspeed internet, some
dialup and some cellular modems.
When using the Aircard (Wireless PC card cellular modem), after 120 seconds
the connection is being dropped. This is happening during the SQL server
initial synchronize process (and perhaps during subsequent merge processes
though they wouldn't likely be more than 120 seconds).
We of course thought it was the Aircard dropping the connection thinking
there was no activity but even when we opened a browser and surfed the
Internet during the synchronization process, it still dropped the connection.
When we simply surfed the Internet (without the synchronize process running)
it never dropped the connection.
Is there a fix? Do I need to have a function going in another thread to fake
a heartbeat to the publisher Sql server from the laptop?
Thanks!
Hello Buzz,
This is typically something you set on the modem itself. Check the configuration
of it to see if the is an auto disconnection after x minutes of inactivity.
Hilary

> Using Merge replication.
> Publisher is Sql Server 2000 SP4, subscribers are laptops using MSDE
> SP4.
> Using anonymous subscribers that use the SQLMerge object to invoke
> replication. Our laptops are everywhere. Some use highspeed internet,
> some dialup and some cellular modems.
> When using the Aircard (Wireless PC card cellular modem), after 120
> seconds the connection is being dropped. This is happening during the
> SQL server initial synchronize process (and perhaps during subsequent
> merge processes though they wouldn't likely be more than 120 seconds).
> We of course thought it was the Aircard dropping the connection
> thinking
> there was no activity but even when we opened a browser and surfed the
> Internet during the synchronization process, it still dropped the
> connection.
> When we simply surfed the Internet (without the synchronize process
> running)
> it never dropped the connection.
> Is there a fix? Do I need to have a function going in another thread
> to fake a heartbeat to the publisher Sql server from the laptop?
> Thanks!
>
|||My client has been working with the phone company on this issue. I am not
working on it directly. However, my understanding is from them that they've
rulled out the settings of the modem being an issue and supposedly the phone
company has had issues with Sql Server before. I was suppose to check on
something called Sql Server latency but that only seems to point to postings
about the time between merge agents which is totally unrelated.
Thanks,
Buzz
"Hilary Cotter" wrote:

> Hello Buzz,
> This is typically something you set on the modem itself. Check the configuration
> of it to see if the is an auto disconnection after x minutes of inactivity.
> Hilary
>
>
|||Hello Buzz,
I agree with Hilary. Based on the symptom, it seems to be network issue
related to wireless modem under high load to replication. You may want to
download or copy big files via this network or use special tool from phone
company to check the error code rate.
It is not likely SQL replicaiton will drop the connection because it is
based on higher protocols such as TCP which is not related to modem
directly.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Can't replicate with cellular modem.
| thread-index: AcXNH3N3SFSz00jSR8q0eK8whAmWuw==
| X-WBNR-Posting-Host: 68.145.59.227
| From: "=?Utf-8?B?QnV6eg==?=" <buzz@.online.nospam>
| References: <B88E11B9-6828-4098-B476-A8BEBB1CB736@.microsoft.com>
<56bbe4560a878c79b0e0191d820@.msnews.microsoft.com>
| Subject: Re: Can't replicate with cellular modem.
| Date: Sun, 9 Oct 2005 15:19:01 -0700
| Lines: 49
| Message-ID: <E36785DD-DA79-4A66-B81C-5053E82CB290@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.replication
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.replication:65767
| X-Tomcat-NG: microsoft.public.sqlserver.replication
|
| My client has been working with the phone company on this issue. I am not
| working on it directly. However, my understanding is from them that
they've
| rulled out the settings of the modem being an issue and supposedly the
phone
| company has had issues with Sql Server before. I was suppose to check on
| something called Sql Server latency but that only seems to point to
postings
| about the time between merge agents which is totally unrelated.
|
| Thanks,
| Buzz
|
| "Hilary Cotter" wrote:
|
| > Hello Buzz,
| >
| > This is typically something you set on the modem itself. Check the
configuration
| > of it to see if the is an auto disconnection after x minutes of
inactivity.
| >
| > Hilary
| >
| > > Using Merge replication.
| > >
| > > Publisher is Sql Server 2000 SP4, subscribers are laptops using MSDE
| > > SP4.
| > >
| > > Using anonymous subscribers that use the SQLMerge object to invoke
| > > replication. Our laptops are everywhere. Some use highspeed internet,
| > > some dialup and some cellular modems.
| > >
| > > When using the Aircard (Wireless PC card cellular modem), after 120
| > > seconds the connection is being dropped. This is happening during the
| > > SQL server initial synchronize process (and perhaps during subsequent
| > > merge processes though they wouldn't likely be more than 120 seconds).
| > >
| > > We of course thought it was the Aircard dropping the connection
| > > thinking
| > > there was no activity but even when we opened a browser and surfed the
| > > Internet during the synchronization process, it still dropped the
| > > connection.
| > > When we simply surfed the Internet (without the synchronize process
| > > running)
| > > it never dropped the connection.
| > > Is there a fix? Do I need to have a function going in another thread
| > > to fake a heartbeat to the publisher Sql server from the laptop?
| > >
| > > Thanks!
| > >
| >
| >
| >
|
|||Okay, with a bit more experimentation and googling, we think it is the FTP
part of the merge replication that is dieing on us. We tried FTPing directly
and got "the connection with the server was reset". Googling showed that
people said it was because the client was running in passive, not active mode.
Another poster from 2001 said that he discovered that merge repliction FTP's
some files, processes some files and then FTP's some more. Problem with this
is that the server can shut the FTP down.
Does Merge ActiveX use passive FTP? If so, how to work around it? We are
using IIS's FTP server, can the server be set to wait longer?
"Peter Yang [MSFT]" wrote:

> Hello Buzz,
> I agree with Hilary. Based on the symptom, it seems to be network issue
> related to wireless modem under high load to replication. You may want to
> download or copy big files via this network or use special tool from phone
> company to check the error code rate.
> It is not likely SQL replicaiton will drop the connection because it is
> based on higher protocols such as TCP which is not related to modem
> directly.
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> | Thread-Topic: Can't replicate with cellular modem.
> | thread-index: AcXNH3N3SFSz00jSR8q0eK8whAmWuw==
> | X-WBNR-Posting-Host: 68.145.59.227
> | From: "=?Utf-8?B?QnV6eg==?=" <buzz@.online.nospam>
> | References: <B88E11B9-6828-4098-B476-A8BEBB1CB736@.microsoft.com>
> <56bbe4560a878c79b0e0191d820@.msnews.microsoft.com>
> | Subject: Re: Can't replicate with cellular modem.
> | Date: Sun, 9 Oct 2005 15:19:01 -0700
> | Lines: 49
> | Message-ID: <E36785DD-DA79-4A66-B81C-5053E82CB290@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.replication
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.replication:65767
> | X-Tomcat-NG: microsoft.public.sqlserver.replication
> |
> | My client has been working with the phone company on this issue. I am not
> | working on it directly. However, my understanding is from them that
> they've
> | rulled out the settings of the modem being an issue and supposedly the
> phone
> | company has had issues with Sql Server before. I was suppose to check on
> | something called Sql Server latency but that only seems to point to
> postings
> | about the time between merge agents which is totally unrelated.
> |
> | Thanks,
> | Buzz
> |
> | "Hilary Cotter" wrote:
> |
> | > Hello Buzz,
> | >
> | > This is typically something you set on the modem itself. Check the
> configuration
> | > of it to see if the is an auto disconnection after x minutes of
> inactivity.
> | >
> | > Hilary
> | >
> | > > Using Merge replication.
> | > >
> | > > Publisher is Sql Server 2000 SP4, subscribers are laptops using MSDE
> | > > SP4.
> | > >
> | > > Using anonymous subscribers that use the SQLMerge object to invoke
> | > > replication. Our laptops are everywhere. Some use highspeed internet,
> | > > some dialup and some cellular modems.
> | > >
> | > > When using the Aircard (Wireless PC card cellular modem), after 120
> | > > seconds the connection is being dropped. This is happening during the
> | > > SQL server initial synchronize process (and perhaps during subsequent
> | > > merge processes though they wouldn't likely be more than 120 seconds).
> | > >
> | > > We of course thought it was the Aircard dropping the connection
> | > > thinking
> | > > there was no activity but even when we opened a browser and surfed the
> | > > Internet during the synchronization process, it still dropped the
> | > > connection.
> | > > When we simply surfed the Internet (without the synchronize process
> | > > running)
> | > > it never dropped the connection.
> | > > Is there a fix? Do I need to have a function going in another thread
> | > > to fake a heartbeat to the publisher Sql server from the laptop?
> | > >
> | > > Thanks!
> | > >
> | >
> | >
> | >
> |
>
|||Hello Buzz,
FTP is used for the snapshot download, both during the initial application
and when the subscription is re-initialized. All other synchronizations use
SQL packets over TCP/IP to transfer data between Publisher and Subscriber.
Did you publish data over Internet? Or did you manually configure
publication to store snapshot via FTP?
You may consider create VPN connection between server/client instead of
using Interent publication.
MergePublication2 control could be used to configruation FTP feature for
snapshot on publisher.
SQL replication can only use active mode FTP. It is not possible to do
passive MODE FTP using SQL replication. The INTERNET_FLAG_PASSIVE has to
be set in FTP connection to do passive mode Ftp. However, this option is
not implemented in SQL replication.
Anyway, it is weird that FTP connection reset could drop WAN connection
because it is higher level ftp protocol based on TCPIP protocols. WAN
connection is based on lower level such as data link layer. You may want to
use different ISP/wireless modem to test this.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Can't replicate with cellular modem.
| thread-index: AcXPoPJCdBSSfQOHQ1iA5xqQ6wGeXg==
| X-WBNR-Posting-Host: 68.145.59.227
| From: "=?Utf-8?B?QnV6eg==?=" <buzz@.online.nospam>
| References: <B88E11B9-6828-4098-B476-A8BEBB1CB736@.microsoft.com>
<56bbe4560a878c79b0e0191d820@.msnews.microsoft.com>
<E36785DD-DA79-4A66-B81C-5053E82CB290@.microsoft.com>
<4kdWUTWzFHA.424@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: Can't replicate with cellular modem.
| Date: Wed, 12 Oct 2005 19:51:01 -0700
| Lines: 124
| Message-ID: <688D9A3C-5FC2-4E96-9D3A-88231CCC5DC2@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.replication
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.replication:17070
| X-Tomcat-NG: microsoft.public.sqlserver.replication
|
| Okay, with a bit more experimentation and googling, we think it is the
FTP
| part of the merge replication that is dieing on us. We tried FTPing
directly
| and got "the connection with the server was reset". Googling showed that
| people said it was because the client was running in passive, not active
mode.
|
| Another poster from 2001 said that he discovered that merge repliction
FTP's
| some files, processes some files and then FTP's some more. Problem with
this
| is that the server can shut the FTP down.
|
| Does Merge ActiveX use passive FTP? If so, how to work around it? We are
| using IIS's FTP server, can the server be set to wait longer?
|
| "Peter Yang [MSFT]" wrote:
|
| > Hello Buzz,
| >
| > I agree with Hilary. Based on the symptom, it seems to be network issue
| > related to wireless modem under high load to replication. You may want
to
| > download or copy big files via this network or use special tool from
phone
| > company to check the error code rate.
| >
| > It is not likely SQL replicaiton will drop the connection because it is
| > based on higher protocols such as TCP which is not related to modem
| > directly.
| >
| > Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > When responding to posts, please "Reply to Group" via your newsreader
so
| > that others may learn and benefit from your issue.
| >
| > ================================================== ===
| >
| >
| >
| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| > --
| > | Thread-Topic: Can't replicate with cellular modem.
| > | thread-index: AcXNH3N3SFSz00jSR8q0eK8whAmWuw==
| > | X-WBNR-Posting-Host: 68.145.59.227
| > | From: "=?Utf-8?B?QnV6eg==?=" <buzz@.online.nospam>
| > | References: <B88E11B9-6828-4098-B476-A8BEBB1CB736@.microsoft.com>
| > <56bbe4560a878c79b0e0191d820@.msnews.microsoft.com>
| > | Subject: Re: Can't replicate with cellular modem.
| > | Date: Sun, 9 Oct 2005 15:19:01 -0700
| > | Lines: 49
| > | Message-ID: <E36785DD-DA79-4A66-B81C-5053E82CB290@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.replication
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| > | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.sqlserver.replication:65767
| > | X-Tomcat-NG: microsoft.public.sqlserver.replication
| > |
| > | My client has been working with the phone company on this issue. I am
not
| > | working on it directly. However, my understanding is from them that
| > they've
| > | rulled out the settings of the modem being an issue and supposedly
the
| > phone
| > | company has had issues with Sql Server before. I was suppose to check
on
| > | something called Sql Server latency but that only seems to point to
| > postings
| > | about the time between merge agents which is totally unrelated.
| > |
| > | Thanks,
| > | Buzz
| > |
| > | "Hilary Cotter" wrote:
| > |
| > | > Hello Buzz,
| > | >
| > | > This is typically something you set on the modem itself. Check the
| > configuration
| > | > of it to see if the is an auto disconnection after x minutes of
| > inactivity.
| > | >
| > | > Hilary
| > | >
| > | > > Using Merge replication.
| > | > >
| > | > > Publisher is Sql Server 2000 SP4, subscribers are laptops using
MSDE
| > | > > SP4.
| > | > >
| > | > > Using anonymous subscribers that use the SQLMerge object to invoke
| > | > > replication. Our laptops are everywhere. Some use highspeed
internet,
| > | > > some dialup and some cellular modems.
| > | > >
| > | > > When using the Aircard (Wireless PC card cellular modem), after
120
| > | > > seconds the connection is being dropped. This is happening
during the
| > | > > SQL server initial synchronize process (and perhaps during
subsequent
| > | > > merge processes though they wouldn't likely be more than 120
seconds).
| > | > >
| > | > > We of course thought it was the Aircard dropping the connection
| > | > > thinking
| > | > > there was no activity but even when we opened a browser and
surfed the
| > | > > Internet during the synchronization process, it still dropped the
| > | > > connection.
| > | > > When we simply surfed the Internet (without the synchronize
process
| > | > > running)
| > | > > it never dropped the connection.
| > | > > Is there a fix? Do I need to have a function going in another
thread
| > | > > to fake a heartbeat to the publisher Sql server from the laptop?
| > | > >
| > | > > Thanks!
| > | > >
| > | >
| > | >
| > | >
| > |
| >
| >
|