+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 14

Does Access Internet Synchronization only need one server with fixedIP?

  1. Does Access Internet Synchronization only need one server with fixedIP?

    I am starting to study internet synchronization, and my head is still
    spinning since internet is not my forte, however my boss is breathing
    down my neck at the moment. Our company has only one server with fixed
    IP address provided by our ISP, while the other sites (which I wish in
    the future hold the replicas databases) have only standard internet
    connections with Dynamic IP (which means that they change IP
    addresses, as given by the ISP every time we connect to the ISP, which
    is a lot cheaper than the fixed IP address connection here). My quick
    and fast understanding of reading what I can at the moment about
    Internet synchronization, seems to tell me that this is OK. All I need
    is one fixed IP server, and other replicas made from the database in
    that server can connect with standard internet connection to
    synchronize (though I still need to understand how this internet
    synchronization works fully).

    Am I correct to understand that? That is, for internet
    synchronization, all is needed is a single fixed IP server, and the
    other replicas can connect to the internet using standard connection
    (Dynamic IP/non fixed IP) anywhere and still can synchronize properly
    with the database in the fixed IP server? Is that why it is called
    anonymous replicas? Any down side on that one?

    Thank you so much

  2. Re: Does Access Internet Synchronization only need one server with fixedIP?

    Sorry, you been confused by the name of this newsgroup! The "access" here
    refers not to Internet access, but rather to Microsoft's Access, which is a
    relational database development program.

    You need to find a forum/newsgroup more appropriate to your problem.

    Good luck!

    --
    There's ALWAYS more than one way to skin a cat!

    Answers/posts based on Access 2000/2003

    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/For...ccess/200809/1


  3. Re: Does Access Internet Synchronization only need one server with fixed IP?

    ingejg@gmail.com wrote in
    news:ce90628a-e369-4384-a254-3dd97e04ea18@b2g2000prf.googlegroups.com
    :

    > I am starting to study internet synchronization, and my head is
    > still spinning since internet is not my forte, however my boss is
    > breathing down my neck at the moment. Our company has only one
    > server with fixed IP address provided by our ISP,


    Stop right there. Internet Replication requires the Internet
    synchronizer to run on the web server to work (and it has to be IIS,
    BTW). I don't know of any ISP that's going to allow that. This is
    one of the many reasons why I have always recommended against using
    Internet Replication -- it introduces too many outside dependencies,
    and one of those dependencies is on the worst web server ever (i.e.,
    IIS).

    > while the other sites (which I wish in
    > the future hold the replicas databases) have only standard
    > internet connections with Dynamic IP (which means that they change
    > IP addresses, as given by the ISP every time we connect to the
    > ISP, which is a lot cheaper than the fixed IP address connection
    > here). My quick and fast understanding of reading what I can at
    > the moment about Internet synchronization, seems to tell me that
    > this is OK.


    Yes, if you have a web server with a fixed IP address that is
    running Windows and IIS and you have permission to run an executable
    on it (i.e., the Internet synchronizer), then, yes, it can be done
    that way. IIS doesn't need to be running on the remote PCs, nor do
    they need fixed IP addresses.

    > All I need
    > is one fixed IP server, and other replicas made from the database
    > in that server can connect with standard internet connection to
    > synchronize (though I still need to understand how this internet
    > synchronization works fully).
    >
    > Am I correct to understand that? That is, for internet
    > synchronization, all is needed is a single fixed IP server, and
    > the other replicas can connect to the internet using standard
    > connection (Dynamic IP/non fixed IP) anywhere and still can
    > synchronize properly with the database in the fixed IP server?


    This is correct.

    > Is that why it is called
    > anonymous replicas? Any down side on that one?


    Anonymous replicas have zilch to do with Internet replication. They
    were introduced in Jet 4, and Internet replication predates that.

    But you don't want to use anonymous replicas, anyway, as they are
    just a terrible idea:

    http://trigeminal.com/usenet/usenet027.asp?1033

    You should really familiarize yourself with everything on that
    website relating to replication before you commit to anything at
    all.

    --
    David W. Fenton http://www.dfenton.com/
    usenet at dfenton dot com http://www.dfenton.com/DFA/

  4. Re: Does Access Internet Synchronization only need one server with fixed IP?

    "Linq Adams via AccessMonster.com" wrote in
    news:899937d75c4ab@uwe:

    > Sorry, you been confused by the name of this newsgroup! The
    > "access" here refers not to Internet access, but rather to
    > Microsoft's Access, which is a relational database development
    > program.
    >
    > You need to find a forum/newsgroup more appropriate to your
    > problem.


    I think you are showing that you don't know everything there is to
    know about Access, as the question was about Internet Replication,
    which Jet has supported since at least Jet 3.5.

    --
    David W. Fenton http://www.dfenton.com/
    usenet at dfenton dot com http://www.dfenton.com/DFA/

  5. Re: Does Access Internet Synchronization only need one server withfixed IP?

    Dear David,
    Thank you for the help. I understand your concern, and I am trying to
    go through your Jet Replication Wiki right now, with all the
    recommended readings. My problem is that it seems that my hands are
    tied. We live in a country where the internet connection is far from
    being reliable. Though it is supposed to have 1Mbps speed, at times it
    simply does not want to work at all. At the same time, we have a few
    sites together. We need to consolidate the data and at the moment, it
    is a nightmare. I have considered web application, but that will be
    hell during the low speed connection. So, the idea I can do is to
    change our main server (currently running on Windows Server 2003) to
    be a temporary web server, and synchonized all the databases on all
    sites during the good speed connection time, say midnight, daily. I
    thought I only need a fix IP address to change that server to become a
    web server. Am I wrong to think that?

    If you have better suggestion, I would love to hear from you. My
    company is also too small to spend too much on expensive software or
    hardware.

    Again, thank you so much for your help.

    Best Regards,
    Indra

  6. Re: Does Access Internet Synchronization only need one server withfixed IP?

    OK, I found out what VPN is:Virtual Private Network, need to study
    more into it. My other questions stilll stand, especially regarding
    other reading materials about indirect replication. Thank you so much

  7. Re: Does Access Internet Synchronization only need one server withfixed IP?

    OK, I found out what VPN is:Virtual Private Network, need to study
    more into it. My other questions stilll stand, especially regarding
    other reading materials about indirect replication. Thank you so much

  8. Re: Does Access Internet Synchronization only need one server with fixed IP?

    ingejg@gmail.com wrote in
    news:28cad0c8-128b-4d71-ae80-9ba9211bb9be@n33g2000pri.googlegroups.co
    m:

    > Thank you once again, I will try to look into VPN. May I know what
    > does it stand for?


    A VPN is a Virtual Private Network. It creates an encrypted tunnel
    across the Internet that is invisible to anyone not connected the
    VPN (or its affliated networks). When you're connected to a VPN
    across the Internet you have the exact same access that you would if
    your were connected to the LAN at the end point of your VPN (just
    slower, since it has to go across the Internet).

    > I remember something about indirect replication
    > when I scan quickly your wiki, I am still going through it slowly
    > to fully understand it, but I have not got to indirect replication
    > yet. Is it explained there as well? Any good recommended sites to
    > read?


    You should start with the Microsoft White Papers, and Replication
    FAQs, I think. The stuff on the Wiki is more practical suggestions
    as to how to implement it. You still need the overview before that
    stuff will make much sense.

    > As I mentioned earlier, though I am keen on the web app, our main
    > concern is that our internet traffic are so unreliable here. While
    > intra-site data processing are needed to be quick, our inter-sites
    > updates can wait for a day or two.


    I don't know what you mean here. Both Internet replication and
    indirect replication are perfect for synchronizing across
    high-latency networks, because they don't depend on opening the
    remote replica across the network connection (which is both slow and
    disastrously dangerous).

    > And, to add extra prespective too,
    > labour cost here (including mine) are way lower than in US, by the
    > way. An average programmer here earns US$2500/year (but our cost
    > of living are lower too, of course). Not that I am complaining,
    > but just to show you the reasons why somethings are done the way
    > it is.


    But surely it's all relative -- that the labor cost is low does not
    mean that relative to the other costs it won't be a high expense.

    --
    David W. Fenton http://www.dfenton.com/
    usenet at dfenton dot com http://www.dfenton.com/DFA/

  9. Re: Does Access Internet Synchronization only need one server withfixed IP?

    OK, thank you so much again. I will try to learn all that first for
    now. Much appreciated.

    Just to explain a bit more about labour cost. Well, it does make a
    difference, because cost of materials (including computers,
    international softwares) are still global price. For example, in the
    factory that I work in, the total labour cost amounts to only 3% of
    total cost. A friend of mine from United States told me that over
    there, for exactly the same industry, the labour cost amounts to 35%
    of the total cost. Hence, in a place like US, purchasing material will
    need to consider the impact of the labour cost, while in our country,
    though it is taken into consideration, it has much less of an impact.
    Sadly, for some of us.

    Anyway, again, I really appreciate all the help. Thank you so very much

  10. Re: Does Access Internet Synchronization only need one server with fixed IP?

    ingejg@gmail.com wrote in
    news:b16ac31f-d695-4c71-90d9-16de5446319b@a1g2000hsb.googlegroups.com
    :

    > Just to explain a bit more about labour cost. Well, it does make a
    > difference, because cost of materials (including computers,
    > international softwares) are still global price. For example, in
    > the factory that I work in, the total labour cost amounts to only
    > 3% of total cost. A friend of mine from United States told me that
    > over there, for exactly the same industry, the labour cost amounts
    > to 35% of the total cost. Hence, in a place like US, purchasing
    > material will need to consider the impact of the labour cost,
    > while in our country, though it is taken into consideration, it
    > has much less of an impact. Sadly, for some of us.


    Are you considering long-term maintenance? Jet replication is very
    picky and needs constant care, whereas with Windows Terminal Server,
    it's all centralized in one place.

    Secondly, in regard to hardware:

    If you've already got a Windows server (2000 or 2003) then all you
    need to make it into a Windows Terminal Server is the licenses
    (which sell for c. $40 ea. in the US) and sufficient RAM (I would
    want 128MBs for each simultaneous user). Bandwidth is not
    necessarily a huge consideration, as WTS can work well even over
    dialup if you tune your Remote Desktop session properly.

    In other words, most of the hardware you need may already be in
    place, and all that might be needed would be the CALs and some extra
    RAM.

    --
    David W. Fenton http://www.dfenton.com/
    usenet at dfenton dot com http://www.dfenton.com/DFA/

+ Reply to Thread
Page 1 of 2 1 2 LastLast