sql server connect: 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

Does the subscription and subscription database already exist on the
subscriber when you run this code?

Regards,
Farooq Mahmud [MS SQL Support]

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

You need to add the subscription to the publication using the
AddSubscription method. See the following article for details:

319647 HOW TO: Program the SQL Merge Control by Using Visual Basic .NET
http://support.microsoft.com/?id=319647

Regards,
Farooq Mahmud [MS SQL Support]

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.