Hi Friends,
We used SQLMERGXLib.SQLMerge in our VB.NET windows client
application for calling sql server 2000 replication. Now
we need to move to sql 2005 for using the http file
transfer feature. The SQLMERGXLib.dll comes with sql
server 2000. I try to find out what is the equivalent
library for sql 2005, but I did not find anything
mentioned that. The following is part of code using sql
2000 merge library SQLMERGXLib.
Private WithEvents rpDatabase As New
SQLMERGXLib.SQLMerge
rpDatabase.Publisher = argRemoteSQLServerName
rpDatabase.PublisherAddress = argServer
rpDatabase.PublisherLogin = argRemoteSQLServerUser
rpDatabase.PublisherPassword =
argRemoteSQLServerPsswd
rpDatabase.PublisherSecurityMode =
SQLMERGXLib.SECURITY_TYPE.DB_AUTHENTICATION
rpDatabase.PublisherNetwork =
SQLMERGXLib.NETWORK_TYPE.TCPIP_SOCKETS
rpDatabase.Publication = argPublication
rpDatabase.PublisherDatabase =
argPublisherDatabase
rpDatabase.HostName = strHostName
rpDatabase.FileTransferType =
SQLMERGXLib.FILE_TRANSFER_TYPE.FILETRANSFERFTP
'Set Subscriber properties.
'rpDatabase.Subscriber = strSubscriber
rpDatabase.Subscriber = Environ("COMPUTERNAME")
rpDatabase.SubscriberSecurityMode =
SQLMERGXLib.SECURITY_TYPE.NT_AUTHENTICATION
rpDatabase.SubscriberDatabase = argDatabase
rpDatabase.SubscriptionType =
SQLMERGXLib.SUBSCRIPTION_TYPE.ANONYMOUS
rpDatabase.SynchronizationType =
SQLMERGXLib.SYNCHRONIZATION_TYPE.AUTOMATIC
'Set Distributor properties. Assume distributor
and publisher are the same machine.
rpDatabase.Distributor = rpDatabase.Publisher
rpDatabase.DistributorAddress =
rpDatabase.PublisherAddress
rpDatabase.DistributorLogin =
rpDatabase.PublisherLogin
rpDatabase.DistributorPassword =
rpDatabase.PublisherPassword
rpDatabase.DistributorSecurityMode =
SQLMERGXLib.SECURITY_TYPE.DB_AUTHENTICATION
rpDatabase.DistributorNetwork =
SQLMERGXLib.NETWORK_TYPE.TCPIP_SOCKETS
Please help me out if you know what is the 2005
equivalent merge library and where to get.
Thank you very much!
