sqlserver.ce merge replication setup question

Discussion in 'microsoft.public.sqlserver.ce' started by Neil Kiser, Aug 24, 2004.

  1. Neil Kiser

    Neil Kiser Guest

    I am new to using sqlserver.ce, and while I have many questions, most of them
    I am working through by trial and error. However, I have one question that
    is troubling me that I thought perhaps it would be best for me to reach out
    for help.
    I have noticed that when I run the "SQL Server CE Connectivity Management"
    Utility that when I use the "configure NTFS permissions wizard" that it fails
    when I specify the UNC string for the network share on my local developer
    workstation. Now, it only fails if I am disconnected from a network, which I
    frequently am. It works fine when I am connected to a network.
    Now here's my question... I really don't care if this utility doesn't work
    when I am disconnected from the network but, it raises the question as to
    whether some of the other problems I am trying to solve (sqlserver.ce merge
    replication problems) are related to the same issue. Again, I am often
    disconnected from networks, but my laptop has a built-in network card, so I
    know I am running a TCP/IP stack (and I can access web sites on my laptop).
    I went in and switched my laptop from a DHCP client to static IP. I also
    updated the LMhosts file to include an entry for my workstation name/IP
    address. So far nothing is allowing me to connect to UNC mappings that are
    shared from the same machine.
    In the end, I don't care about any of this so long as I can be certain that
    replication can occur even if I am disconnected from a network (BTW, I am
    replicating to the Pocket PC emulator in VS 2003 when I am disconnected from
    a network). If it does matter, which I suspect is true, then I'm uncertain
    how to enable UNC mappings to from my laptop, going to my laptop, when I am
    disconnected.
    Any insights are greatly appreciated.
    Thank you.
    -Neil K.
     
    Neil Kiser, Aug 24, 2004
    #1
    1. Advertisements

  2. If SQL Server does not have a NIC activated, then there are issues with
    creating the snapshot files. I suspect that this is the problem you are
    experiencing. If you want to workaround this problem, you can install the
    MS Loopback adapter and then that will provide a fictitious network
    connection. Please try this to see if it resolves your particular problem.
     
    Kevin Collins \(MS - SQL Mobile\), Aug 25, 2004
    #2
    1. Advertisements

  3. Neil Kiser

    Neil Kiser Guest

    One last note: The emulator can connect to local web sites using the IP
    address, it can also connect out onto the web and does not require IP
    addressing for those sites. It's only my local web sites, and it's only the
    emulator, not my real handheld.
     
    Neil Kiser, Aug 25, 2004
    #3
  4. Neil Kiser

    Neil Kiser Guest

    I have no idea why it started working, but everything appears to be working
    this morning.

    But as a general aside, since the handheld (emulator included) has no place
    to enter a DNS server (I'm speaking of a non-networked handheld - Activesync
    only), what does it use to resolve names? Does it use the settings of the
    host computer?

    This just strikes me as a strange problem (meaning
    out-of-the-ordinary-standard-problems one faces). But I figure my path to
    enlightenment begins by understanding how it is supposed to work. So if
    anyone happens to know how a handlheld using ActiveSync via USB only (no NIC)
    resolves www.microsoft.com or my local machine name, I would appreciate the
    education.

    Thanks,
     
    Neil Kiser, Aug 26, 2004
    #4
  5. What emulator are you using? PPC 2003 or PPC 2002?
     
    Kevin Collins \(MS - SQL Mobile\), Aug 26, 2004
    #5
  6. Neil Kiser

    Neil Kiser Guest

    Sorry for the delayed response, I was on vacation.

    I am using, primarily, the PPC 2003 emulator.
     
    Neil Kiser, Sep 22, 2004
    #6
  7. I was on vacation also....

    I would try posting this question on the visual studio 2003 newsgroup. I
    don't know how to solve this particular problem.
     
    Kevin Collins \(MS - SQL Mobile\), Sep 29, 2004
    #7
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.