Re: VB.Net and MSDE Replication

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jim Johnston (johnston_at_mounet.com)
Date: 02/22/04

  • Next message: Paul Ibison: "RE: Using merge replication for high availability (in addition to a cluster)" 
    Date: 22 Feb 2004 10:29:31 -0800

    Questions for you:
    Have you applied SP3? It is required for VB.NET to run the
    MergeObject correctly, especially the Status event.
    Does it work with NT Authentication? If so, are you running in mixed
    mode on your subscriber. You will need to be in mixed mode to use DB
    Authentication
    Do you have a separate Distributor? I don't see any Distributor logon
    in you code.
    V/R Jim Johnston
    MCSD.NET, MCDBA

    "John@hokykoky.com" <John@hokykoky.com> wrote in message news:<ckqf305j6stc4v90n2rlcm4uvghv68jlvj@4ax.com>...
    > I am trying to create the initial database from a snapshot on my SHED1
    > MS SQL server. Whenever I run the code below, I get the following
    > error:
    >
    > 'The subscription to publication 'SteelPMOSql1' has expired or does
    > not exist'
    >
    > When I installed MSDE 2000, I did not set the install option to change
    > the security mode to SQL... Will this have any effect as I am using
    > DB_AUTHENTICATION below? Alternatively, any help on why this error
    > occurs would be appreciated.
    >
    >
    >
    > Private Sub RunReplMerge()
    > Dim strPhase As String
    >
    > 'Try
    >
    > mobjMerge = New SQLMERGXLib.SQLMerge
    >
    > With mobjMerge
    > strPhase = "Setup"
    >
    > .Publisher = "SHED1"
    > .PublisherDatabase = "SteelPMOSQL"
    > .PublisherLogin = "sa"
    > .PublisherPassword = ""
    > .PublisherSecurityMode =
    > SQLMERGXLib.SECURITY_TYPE.DB_AUTHENTICATION
    >
    >
    >
    > .Publication = "SteelPMOsql1"
    >
    > .Subscriber = "SHED2"
    > .SubscriberSecurityMode =
    > SQLMERGXLib.SECURITY_TYPE.DB_AUTHENTICATION
    > .SubscriberLogin = "sa"
    > .SubscriberPassword = ""
    > .SubscriberDatabase = "PERSONALPMO"
    > .SubscriberDatasourceType =
    > SQLMERGXLib.DATASOURCE_TYPE.SQL_SERVER
    >
    > .SubscriptionType = SQLMERGXLib.SUBSCRIPTION_TYPE.PUSH
    >
    > strPhase = "Initialize"
    > .Initialize()
    > strPhase = "Run"
    > .Run()
    > strPhase = "Terminate"
    > .Terminate()
    > End With
    > Exit Sub
    >
    > End Sub
    >
    >
    > ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
    > http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
    > ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

  • Next message: Paul Ibison: "RE: Using merge replication for high availability (in addition to a cluster)"

    Relevant Pages

    • Re: SQL Web Admin - cant logon
      ... Is it a default instance or a named instance? ... SQL Server MVP ... > I have installed MSDE and can access it via Access or Visual ... please ensure that SQL Server Authentication is enabled on the ...
      (microsoft.public.sqlserver.msde)
    • Re: MSDE 2000 SP3a on a Windows 2003 server
      ... Are you sure you installed MSDE 2000 SP3a? ... install on 2003 but you will get a warning in the event log that the ... Also look in the log for SQL Server and see whether it is loading any ... > machine with any valid account, ...
      (microsoft.public.sqlserver.msde)
    • RE: Settig SQL Agent pwd thru code
      ... I think you want to change the MSDE authentication mode to SQL Server ... If you installed MSDE as a named instance, ...
      (microsoft.public.sqlserver.security)
    • COM OBJECT WITH CLSID... IS EITHER NOT VALID OR NOT REGISTERED
      ... I'm developing an application works with SQL Server. ... I've installed MSDE in my PC. ... Any help about how register this dll will be appreciated... ...
      (microsoft.public.dotnet.framework.setup)
    • COM OBJECT WITH CLSID... IS EITHER NOT VALID OR NOT REGISTERED
      ... I'm developing an application works with SQL Server. ... I've installed MSDE in my PC. ... Any help about how register this dll will be appreciated... ...
      (microsoft.public.dotnet.framework.windowsforms)