ActiveX program control merge replication.

Hi There, i am using msde 2000 sp3 and sql 2000 sp3 as a subscriber
and distributer or publisher.
I created a merge replication programatically so when user click
synchronize it synchronize between msde and server. When i try to run
the program the following message come.
" -2147221504- n[microsoft][odbc sql server driver] [tcp/ip sockets]
sql server does not exist or access denied. [microsoft][odbc sql
server driver] connection open connect().
please give me some information why this problem is coming. I would
like to know what are the dependent file or dll file for merge
replication. i am using merger replicaiton with pull subscriber.
the subscriber can be window 2000, xp etc.
I will be thankful if anyone give me some information for this
problem.
Indra.
From what you describe it sounds like you are having a problem connecting to the publisher from the subscriber, and furthermore it sounds like you are having a name resolution problem.
On your subscriber try to ping the publisher.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Indra" wrote:

> Hi There, i am using msde 2000 sp3 and sql 2000 sp3 as a subscriber
> and distributer or publisher.
> I created a merge replication programatically so when user click
> synchronize it synchronize between msde and server. When i try to run
> the program the following message come.
> " -2147221504- n[microsoft][odbc sql server driver] [tcp/ip sockets]
> sql server does not exist or access denied. [microsoft][odbc sql
> server driver] connection open connect().
> please give me some information why this problem is coming. I would
> like to know what are the dependent file or dll file for merge
> replication. i am using merger replicaiton with pull subscriber.
> the subscriber can be window 2000, xp etc.
> I will be thankful if anyone give me some information for this
> problem.
> Indra.
>

Accuracy of replicated data

Hi,
I use dial-up connection to replicate data between to servers. Our
replication type is Merge and I'm worried that what happens if the
connection fails when merge agent is working. Will the synchronization be
rolled back or I must necessarily use Transactional replication?
Thanks in advance,
Leila
"Leila" schrieb:

> Hi,
> I use dial-up connection to replicate data between to servers. Our
> replication type is Merge and I'm worried that what happens if the
> connection fails when merge agent is working. Will the synchronization be
> rolled back or I must necessarily use Transactional replication?
> Thanks in advance,
> Leila
Test it (it should be rolled back - and even if not: the next execution of
the merge agent should synchronize the publisher and subscriber again)!
If you you do not need bidirectional replication it is better to use
transactional replication anyway - it's faster and (unlike the merge
replication) guarantees the consistency of your data!
|||Thanks Christian,
But I'm trying to understand its logic without testing. Because my data are
important and sensitive and I cannot risk for testing!
"Christian Donner" <ChristianDonner@.discussions.microsoft.com> wrote in
message news:44A7E2F0-23EC-490E-82CD-820D15257830@.microsoft.com...[vbcol=seagreen]
> "Leila" schrieb:
be
> Test it (it should be rolled back - and even if not: the next execution of
> the merge agent should synchronize the publisher and subscriber again)!
> If you you do not need bidirectional replication it is better to use
> transactional replication anyway - it's faster and (unlike the merge
> replication) guarantees the consistency of your data!