Re: Replication newbie question(s)
- From: "David W. Fenton" <dXXXfenton@xxxxxxxxxxxxxxxx>
- Date: Thu, 08 Dec 2005 16:31:16 -0600
"SteveW" <swheeler@xxxxxxxxxxxxxx> wrote in
news:Op$4nD5#FHA.828@xxxxxxxxxxxxxxxxxxxx:
> I will only really need to do 1 way updates - from a server to
> client pc with the "shadow" database. When you refer to the
> synchronizer , do you mean mstrai40.exe ? Doesn't JRO supports
> both http and ftp ?
Hmm. I don't know about HTTP. Remember, I have avoided Internet
replication because of the IIS requirement. I know that with Jet
3.5, it was done via FTP. Perhaps Jet 4.0 added HTTP, but that
really doesn't change anything (and I strongly doubt that one would
upload and download files via HTTP -- remember, the synchronizer
has
to write to the dropbox on the *other* machine, not its local
dropbox, so HTTP would have to be writing to a remote machine,
something that I don't believe is possible).
Well, I see that I'm wrong, according to this:
http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/dnac
c2k/html/intrjet4.asp
It doesn't change the dependency on IIS, and it doesn't add any
security, but it does make it more likely you can get through
firewalls that might block FTP. Of course, both are terribly
insecure methods for transferring data, and MS made, in my opinion,
a very stupid mistake when they decided to remove encryption of the
MSG files unless the replica set itself were encrypted. That makes
no sense whatsoever, as the point of encrypting the MSG files is
because they are going across the open Internet. You don't encrypt
your local MDB files unless you are using Jet security, so this is
a
very poor design decision, I believe.
In any event, Internet replication uses the mstrai40.exe
synchronizer. Indirect replication uses the mstran40.exe
synchronizer.
> Here is a bit of a vb code sample that I am using for testing:
>
> Sub InternetSync()
> Dim rep As JRO.Replica
>
> Set rep = New JRO.Replica
>
> rep.ActiveConnection = "D:\Development\test\data
\repltest.mdb"
> rep.Synchronize "http://192.168.1.16/script/repltest.mdb";,
> jrSyncTypeImpExp, jrSyncModeInternet
>
> Set rep = Nothing
> End Sub
>
> But, I get the "Invalid HTTP Address" error. I am very unclear on
> how to setup paths and files, do you have any examples?
I can't help you. I wouldn't touch Internet replication with a
10-foot pole, precisely because there are just way too many
dependencies outside Access that I wouldn't be able to control as
easily.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
.
- References:
- Replication newbie question(s)
- From: SteveW
- Re: Replication newbie question(s)
- From: David W. Fenton
- Re: Replication newbie question(s)
- From: SteveW
- Replication newbie question(s)
- Prev by Date: Re: Linked table somehow became local?
- Next by Date: Re: Replication newbie question(s)
- Previous by thread: Re: Replication newbie question(s)
- Next by thread: Re: Replication newbie question(s)
- Index(es):
Relevant Pages
|
