Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Internet sync failure (Acc 97 SR2)

    Trying to set up Internet synchronization with Acc 97, and am completely stumped. Everytime I try to sync from a workstation, it fails with an error message: "Internal Internet Failure"

    I have followed the instructions from "Internet synchronization with the Jet DBE: Technical Overview" by Michael Wachal.

    Originally set up on Win2000 server running IIS 5.0 -- but since that platform is not explicitly mentioned in the document, I also installed it on a Win98 machine running Personal Web Server 1.0a. In both cases, the result is the same. (tried PWS 4.0, but it does not support FTP, and is not a supported platform for Internet synch)

    I can successfully browse via a web browser to the <server>/synch folder, and upload and download files to the <server>/ftpsynch folder. With IIS, I referred to the server by its IP address, and with PWS, I referred to the server by its Windows name.

    The only troubleshooting tools that I am aware of is the "Test communications" option in the Sync dialog from Access. That fails in exactly the same way as the "real" synch.

    Getting very frustrated by this.... and any help would be gratefully appreciated.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  2. #2
    Star Lounger
    Join Date
    Feb 2001
    Location
    Wirral, Merseyside, Merseyside, England
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Internet sync failure (Acc 97 SR2)

    I've never done what you're trying to do, so this is just a stab in the dark, but as no one else has been able to suggest anything here goes..... Can IIS talk to the database ie: is there an ODBC connection set between the IIS server and Access?

    Use ODBC from Control panel and test the connectivity.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Internet sync failure (Acc 97 SR2)

    I don't know if this applies, but there is a knowledgebase article on this error: <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q173/1/71.ASP>Failed Internet Synchronization Leaves Files on Server [Q173171]</A>.
    Charlotte

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Internet sync failure (Acc 97 SR2)

    So near, yet so far. I followed the instructions in the Article ID: Q173171, and have now gotten to the point where it does leave the .msg files on the server, but still can't advance beyond that point. Previously, it just failed with an "internal internet failure". At least now I know that the ftp part is working -- there is something still wrong with the Web part of the connection.

    Thanks for your help.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  5. #5
    Giovanni
    Guest

    Re: Internet sync failure (Acc 97 SR2)

    I used replication to update a server based MDB but I encountered lots of different problems. Finally completely gave up replication and I use an internal FTP control that first compacts my MDB(s) and then loads it on the internet server.
    Maybe this is an alternative for you?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •