"Darin" <darin_nospam@nospamever> wrote in message
news:OApUxNvgFHA.3220@TK2MSFTNGP10.phx.gbl...
> I have a publication created using SQLDMO on the server.
>
> PublicationAttributes = SQLDMO_PUBATTRIB_TYPE.SQLDMOPubAttrib_AllowPull
> + _
>
> SQLDMO_PUBATTRIB_TYPE.SQLDMOPubAttrib_ImmediateSync + _
>
> SQLDMO_PUBATTRIB_TYPE.SQLDMOPubAttrib_IndependentAgent + _
>
> SQLDMO_PUBATTRIB_TYPE.SQLDMOPubAttrib_AllowAnonymous
>
> I am trying to get a Pull to work from a laptop (in test mode connected
> to the main SQL machine via ethernet, but in the end will be connected
> via the internet).
>
> The Pull is done via ActiveX:
> With myMergeObj
> .Distributor = "IIS-SQL"
> .DistributorLogin = login
> .DistributorPassword = password
> .DistributorSecurityMode = SECURITY_TYPE.DB_AUTHENTICATION
>
> .Publisher = inxRS.Globals.gServer
> .PublisherDatabase = "SAMPLE"
> .Publication = "SAMPLE-RS"
> .PublisherLogin = login
> .PublisherPassword = password
> .PublisherSecurityMode = SECURITY_TYPE.DB_AUTHENTICATION
>
> .Subscriber = Trim(Environment.MachineName)
> .SubscriberDatabase = "SAMPLE"
> .SubscriberSecurityMode = SECURITY_TYPE.DB_AUTHENTICATION
> .SubscriptionType = SUBSCRIPTION_TYPE.PULL
> .SubscriberLogin = login
> .SubscriberPassword = password
> .SubscriptionName = "SAMPLE-RS"
>
> .HostName = Trim(inxRS.Globals.gLogin)
> .ExchangeType = EXCHANGE_TYPE.BIDIRECTIONAL
> End With
>
> myMergeObj.Initialize()
> myMergeObj.Run()
> myMergeObj.Terminate()
>
>
> This errors with:
>
> Server 'IIS-LAPTOP' is not registered at server 'IIS-SQL'.
>
> I thought for PULL all I had to do was create the subscription for
> anonymous access. What am I missing?
>
> Thanks.
> Darin
>
> *** Sent via Developersdex http://www.developersdex.com ***