473,405 Members | 2,294 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

VB.Net and MSDE Replication

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 =---
Nov 20 '05 #1
0 881

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Craig HB | last post by:
I have a distributed inventory control database that I am going to migrate from Access to SQL Server. I am going to use SQL Server Replication to keep the data current. There will one SQL Server...
1
by: Eric B | last post by:
Hello gurus: Hopefully someone can shed some light on some questions I have. I am tasked to build an application that will schedule and track tasks. I firmly believe in not reinventing the wheel...
3
by: Jonathan Bishop | last post by:
Hi. We are using MSDE2000 on a Point of Sale application. We need to keep a copy of a few key tables as up to date as possible for backup purposes. We are looking at using triggers over the...
5
by: Robin Tucker | last post by:
I'm looking for a simple way of telling (inside a stored procedure) if I'm currently using MSDE or a full SQL server. Ideally, there is some pre-defined environment variable that won't cause me...
1
by: smahler | last post by:
Hi all, Here is my situation. I have an application that uses SQL 2000. The client has a program that uses MSDE. The client MUST have the MSDE version of the Database. What I have done is to...
2
by: HJ | last post by:
Hi all, I am looking at a problem we encountered with replication. Our front-end and back-end are Microsoft Access 2000. We have a design master at the server and replicas at five notebooks. The...
8
by: Rick | last post by:
I'm running an Access2000 front end mde linked to an Access2000 back end mdb. I need to set up replication and synchronization of only the data tables between the master db on the pc and replicas...
5
by: Paul Aspinall | last post by:
Can anyone provide any pointers or code examples for Coding an app to use ActiveSync to sync between SQL CE and SQL 2000 / MSDE I want the app to use ActiveSync and to be a Windows form app on...
3
by: Chris Rennert | last post by:
Hello all, We were just getting started on a small project using SQL Server Express on our PC's and we already had SQL Server 2k Enterprise on our main Server. Problem is , we cannot do merge...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.