|
|
|
date: Sun, 21 Oct 2007 20:02:01 -0700,
group: microsoft.public.access.replication
back
Dropbox Declaration for indirect synchronize.
Hi guys,
I have some problems with indirect synchronization. I have studied MS access
synchronization for a week. I have read many articles in the internet.
However, i still can't do it. I have some questions about using TSI with
indirect synchronize.
1. Is it possible to perform indirect synchronization by TSI and JET without
Replication Manager? (I know you would probably answer this question many
time. But i read many articles for the pervious week. Some of them say "Yes
it can". But some of them say "No, it never happen". I just need some
confirmation.)
2. Plesae check my understanding as follow:
2.1 After we set up the server and create the replica, then, we have to
declare the drop box for the server, Isn't it? How?
2.2 How can we check whether dropbox is already declared in Access?
2.3 After the dropbox has already declared, we have to add the replica to
the Managed Replicas. How can I do that?
2.4 I have confused about a properties in TSI. It is
"sync.IndirectDropbox ". How and when we will use it?
2.5 "Sync.IdirectDropBox" is used to set the DropBox for whom? For the
local replica or the remote replica that we are going to sync?
3. Is it possible for anyone to give me some example of source code for
indirect synchronization with TSI?
4. Last but not least, do we have to start mstran.exe manually (double
clieck) everytime before we start indirect synchronization?
I still believe that i can do the indirect synchronization, but i just need
your help.
Thank yo very much.
date: Sun, 21 Oct 2007 20:02:01 -0700
author: Theerachai A. Theerachai
Re: Dropbox Declaration for indirect synchronize.
Glad to see you made it here!
=?Utf-8?B?VGhlZXJhY2hhaSBBLg==?= <Theerachai
A.@discussions.microsoft.com> wrote in
news:245A4D9F-BE30-48E7-978A-E5C3DB0F223A@microsoft.com:
> 1. Is it possible to perform indirect synchronization by TSI and
> JET without Replication Manager? (I know you would probably
> answer this question many time. But i read many articles for the
> pervious week. Some of them say "Yes it can". But some of them say
> "No, it never happen". I just need some confirmation.)
Yes. This question is answered in my Jet Replication Wiki FAQ:
http://www.dfenton.com/DFA/Replication/index.php?title=FAQ
It's kind of complicated, but can be easily programmed into a little
Access database that sets up a PC for you.
> 2. Plesae check my understanding as follow:
>
> 2.1 After we set up the server and create the replica, then, we
> have to
> declare the drop box for the server, Isn't it? How?
You make sure the dropbox share exists (and it should be a top-level
share, i.e., \\Server\Dropbox, rather than
\\Server\SomeFolder\SomeOtherFolder\Dropbox), and then you set the
indirect dropbox property in the TSI Synchronizer. You could also
manually set the registry key for it -- all the registry keys for
the synchronizer are under
HKLM\Software\Microsoft\Jet\N.x\Transporter (where N.x is the Jet
version, which is likely 4.0 in your case). The FSAddress key is the
one where the dropbox path is stored.
> 2.2 How can we check whether dropbox is already declared in
> Access?
The registry key will be set, or you can query the TSI Synchronizer
property.
> 2.3 After the dropbox has already declared, we have to add the
> replica to
> the Managed Replicas. How can I do that?
Via ManagedReplicas.Append method of the TSI Synchonizer. Or, you
can edit the registry key directly (it's called ManagedReplicas, and
is a binary mutliple value, which is a bit tricky to edit manually),
though it's a lot easier to use the TSi Synchronizer.
> 2.4 I have confused about a properties in TSI. It is
> "sync.IndirectDropbox ". How and when we will use it?
The value this is set to will be written to FSAddress field of the
MSysTranspAddress table and used for indirect synchs with that
replica. Each synchronizer has a dropbox associated with it and each
time an indirect synch happens with a particular synchronizer, that
synchronizer's dropbox is used for the indirect synch.
> 2.5 "Sync.IdirectDropBox" is used to set the DropBox for whom?
> For the
> local replica or the remote replica that we are going to sync?
For the synchronizer. Any replicas managed by that synchronizer will
have the dropbox value written to its FSAddress field in
MSysTranspAddress.
> 3. Is it possible for anyone to give me some example of source
> code for indirect synchronization with TSI?
It's pretty simple to do the synch. The hard part is setting up the
synchronizer. The link I cited above refers you to step-by-step
instructions on how to do it.
> 4. Last but not least, do we have to start mstran.exe manually
> (double clieck) everytime before we start indirect
> synchronization?
No. The TSI Synchronizer's Running property will start it and stop
it as long as it is *not* running already. You can only get certain
kinds of information from the synchronizer object of the TSI
Synchronizer if you start that instance of the synchronizer with the
TSI Synchronizer. Because of this, I check to see if the
synchronizer is running, and use a Windows API call to shut it down,
and then restart it with the TSI Synchronizer.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
date: Mon, 22 Oct 2007 14:25:14 -0500
author: David W. Fenton lid
Re: Dropbox Declaration for indirect synchronize.
Hi David;
Thank you very much. Your answer are very useful for us. Now, we have more
undestanding about TSI and JET Replication. We will try to use it again.
Thank you very much....
Theerachai A.
"David W. Fenton" wrote:
> Glad to see you made it here!
>
> =?Utf-8?B?VGhlZXJhY2hhaSBBLg==?= <Theerachai
> A.@discussions.microsoft.com> wrote in
> news:245A4D9F-BE30-48E7-978A-E5C3DB0F223A@microsoft.com:
>
> > 1. Is it possible to perform indirect synchronization by TSI and
> > JET without Replication Manager? (I know you would probably
> > answer this question many time. But i read many articles for the
> > pervious week. Some of them say "Yes it can". But some of them say
> > "No, it never happen". I just need some confirmation.)
>
> Yes. This question is answered in my Jet Replication Wiki FAQ:
>
> http://www.dfenton.com/DFA/Replication/index.php?title=FAQ
>
> It's kind of complicated, but can be easily programmed into a little
> Access database that sets up a PC for you.
>
> > 2. Plesae check my understanding as follow:
> >
> > 2.1 After we set up the server and create the replica, then, we
> > have to
> > declare the drop box for the server, Isn't it? How?
>
> You make sure the dropbox share exists (and it should be a top-level
> share, i.e., \\Server\Dropbox, rather than
> \\Server\SomeFolder\SomeOtherFolder\Dropbox), and then you set the
> indirect dropbox property in the TSI Synchronizer. You could also
> manually set the registry key for it -- all the registry keys for
> the synchronizer are under
> HKLM\Software\Microsoft\Jet\N.x\Transporter (where N.x is the Jet
> version, which is likely 4.0 in your case). The FSAddress key is the
> one where the dropbox path is stored.
>
> > 2.2 How can we check whether dropbox is already declared in
> > Access?
>
> The registry key will be set, or you can query the TSI Synchronizer
> property.
>
> > 2.3 After the dropbox has already declared, we have to add the
> > replica to
> > the Managed Replicas. How can I do that?
>
> Via ManagedReplicas.Append method of the TSI Synchonizer. Or, you
> can edit the registry key directly (it's called ManagedReplicas, and
> is a binary mutliple value, which is a bit tricky to edit manually),
> though it's a lot easier to use the TSi Synchronizer.
>
> > 2.4 I have confused about a properties in TSI. It is
> > "sync.IndirectDropbox ". How and when we will use it?
>
> The value this is set to will be written to FSAddress field of the
> MSysTranspAddress table and used for indirect synchs with that
> replica. Each synchronizer has a dropbox associated with it and each
> time an indirect synch happens with a particular synchronizer, that
> synchronizer's dropbox is used for the indirect synch.
>
> > 2.5 "Sync.IdirectDropBox" is used to set the DropBox for whom?
> > For the
> > local replica or the remote replica that we are going to sync?
>
> For the synchronizer. Any replicas managed by that synchronizer will
> have the dropbox value written to its FSAddress field in
> MSysTranspAddress.
>
> > 3. Is it possible for anyone to give me some example of source
> > code for indirect synchronization with TSI?
>
> It's pretty simple to do the synch. The hard part is setting up the
> synchronizer. The link I cited above refers you to step-by-step
> instructions on how to do it.
>
> > 4. Last but not least, do we have to start mstran.exe manually
> > (double clieck) everytime before we start indirect
> > synchronization?
>
> No. The TSI Synchronizer's Running property will start it and stop
> it as long as it is *not* running already. You can only get certain
> kinds of information from the synchronizer object of the TSI
> Synchronizer if you start that instance of the synchronizer with the
> TSI Synchronizer. Because of this, I check to see if the
> synchronizer is running, and use a Windows API call to shut it down,
> and then restart it with the TSI Synchronizer.
>
> --
> David W. Fenton http://www.dfenton.com/
> usenet at dfenton dot com http://www.dfenton.com/DFA/
>
date: Mon, 22 Oct 2007 20:47:01 -0700
author: Theerachai A.
Re: Dropbox Declaration for indirect synchronize.
=?Utf-8?B?RXZlcmdyZWVu?= wrote
in news:B86E3D5E-3BBB-4A39-8CA8-9AD115DEB440@microsoft.com:
> "David W. Fenton" wrote:
>
>
>> Yes. This question is answered in my Jet Replication Wiki FAQ:
>>
>> http://www.dfenton.com/DFA/Replication/index.php?title=FAQ
>>
>> It's pretty simple to do the synch. The hard part is setting up
>> the synchronizer. The link I cited above refers you to
>> step-by-step instructions on how to do it.
>
> Hi, I have looked at the Wiki but cannot find the step by step
> instructions.
It's question #9.
> I am trying to get indirect synch working using TSI as I cannot
> get my hands on replication manager.
That's precisely what question #9 addresses. It's worded thus:
9 How does one set up indirect replication if you don't have
Replication Manager?
> Due to my basic programming skills I cannot seem to understand the
> instructions on the various posts and TSI help file. Because there
> is a lack of code available, it is difficult to know how to put
> each command together. I can set the drop box and run the Jet
> sychronizer from within VB but have hit a wall when trying to
> manage the replicas (ie. how do I denote the database name, how do
> I denote the replicas, etc, and what system tables can I check to
> see if it has worked).
You use the ManagedReplicas collection of the TSI Synchronizer,
precisely as the instructions in the help file say to do it. The
method of the ManagedReplicas property is .Add.
Checking to see the results, you can look in the registry at
Transporter key (it's under HKLM/Software/Microsoft/Jet/4.0). The
MSysTranspAddress is the table that records it, and you can tell
that the replica is managed by the TransporterDescription field (and
the dropbox location is in the FSAddress field). I've found that it
takes two or three synchs with other replicas before the data shows
up in the MsysTranspAddress tables.
> I understand the process, can create a backend replica and direct
> synch from the menu but need to automate and do indirect synch as
> will have it on two different servers with people using regularly.
> Jet and TSI are loaded correctly and have setup the registry.
>
> I guess I need things a little simpler, if it can be done.
It's not simple! That's one of the problems with it.
Post specific questions and I'm happy to answer them.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
date: 23 Jan 2008 21:56:56 GMT
author: David W. Fenton lid
|
|
