SQLMERGXLib, COM interface constants for VB.Net / VBScript

SQLMERGXLib - interface constants

library parameters

STATUS_RETURN_CODE

Public Enum STATUS_RETURN_CODE

  'The callback function returned success.
  SUCCESS = 0  '&H0

  'Cancel the operation.
  CANCEL = 1  '&H1
End Enum

SECURITY_TYPE

Public Enum SECURITY_TYPE

  'Specifies database authentication for the connection.
  DB_AUTHENTICATION = 0  '&H0

  'Specifies Windows NT authentication for the connection. [Only supported by Microsoft SQL Server on Windows NT.]
  NT_AUTHENTICATION = 1  '&H1

  'Specifies Basic authentication for the connection. [Only supported for specifying Web server connectivity information.]
  BASIC_AUTHENTICATION = 0  '&H0
End Enum

DATASOURCE_TYPE

Public Enum DATASOURCE_TYPE

  'The Subscriber is a Microsoft SQL Server database.
  SQL_SERVER = 0  '&H0

  'The Subscriber is an ODBC data source.
  ODBC_DSN = 1  '&H1

  'The Subscriber is a Microsoft Jet 4.0 database.
  JET4_DATABASE = 2  '&H2

  'The Subscriber is an OLE DB data source.
  OLEDB_DATASOURCE = 3  '&H3

  'The Subscriber is a Microsoft Exchange data source.
  EXCHANGE = 4  '&H4

  'The Subscriber is an Oracle database.
  ORACLE = 5  '&H5

  'The Subscriber is a DB2 Universal database.
  DB2_UNIVERSAL = 6  '&H6

  'The Subscriber is a Microsoft SQL Server CE database.
  SQL_SERVER_CE = 7  '&H7

  'The Subscriber is a XML datasource.
  XML_DATASOURCE = 8  '&H8
End Enum

SUBSCRIPTION_TYPE

Public Enum SUBSCRIPTION_TYPE

  'Push subscription
  PUSH = 0  '&H0

  'Pull subscription
  PULL = 1  '&H1

  'Anonymous subscription
  ANONYMOUS = 2  '&H2

  'Light-weight subscription
  LIGHTWEIGHT = 3  '&H3
End Enum

EXCHANGE_TYPE

Public Enum EXCHANGE_TYPE

  'Upload data changes from the Subscriber to the Publisher.
  UPLOAD = 1  '&H1

  'Download data changes from the Publisher to the Subscriber.
  DOWNLOAD = 2  '&H2

  'Upload and then download changes between the Publisher and Subscriber.
  BIDIRECTIONAL = 3  '&H3
End Enum

NETWORK_TYPE

Public Enum NETWORK_TYPE

  'Use the default client Net-Library for the Microsoft SQL Server connection.
  DEFAULT_NETWORK = 0  '&H0

  'Use the TCP/IP Sockets Net-Library for the Microsoft SQL Server conection.
  TCPIP_SOCKETS = 1  '&H1

  'Use the Multiprotocol Net-Library for the Microsoft SQL Server connection.
  MULTI_PROTOCOL = 2  '&H2
End Enum

VALIDATE_TYPE

Public Enum VALIDATE_TYPE

  'Do not validate the subscriber data.
  NO_VALIDATION = 0  '&H0

  'Perform only a full row count validation of the subscriber data.
  ROWCOUNT_ONLY = 1  '&H1

  'Perform a full count and checksum validation of the subscriber data.
  ROWCOUNT_AND_CHECKSUM = 2  '&H2

  'Perform only a fast row count validation of the subscriber data.
  FAST_ROWCOUNT_ONLY = 3  '&H3

  'Perform a fast count and checksum validation of the subscriber data.
  FAST_ROWCOUNT_AND_CHECKSUM = 4  '&H4

  'Perform a full count and binary checksum validation of the subscriber data.
  ROWCOUNT_AND_BINARYCHECKSUM = 5  '&H5

  'Perform a fast count and binary checksum validation of the subscriber data.
  FAST_ROWCOUNT_AND_BINARYCHECKSUM = 6  '&H6
End Enum

DBADDOPTION

Public Enum DBADDOPTION

  'Use an existing Subscriber database.
  EXISTING_DATABASE = 0  '&H0

  'Create the Subscriber database.
  CREATE_DATABASE = 1  '&H1

  'Attach the Subscriber database file, typically .mdf (Microsoft� SQL Server� Subscribers only).
  ATTACH_DATABASE = 2  '&H2

  'Attach the subscription file, typically .msf (Microsoft� SQL Server� Subscribers only).
  ATTACH_SUBSCRIPTION = 3  '&H3

  'Register the existing subscription.
  REGISTER_SUBSCRIPTION = 4  '&H4
End Enum

SUBSCRIPTION_HOST

Public Enum SUBSCRIPTION_HOST

  'The subscription will not be registered under other hosts.
  NONE = 0  '&H0

  'Register the subscription in Microsoft Synchronization Manager.
  SYNC_MANAGER = 1  '&H1
End Enum

DBDROPOPTION

Public Enum DBDROPOPTION

  'Drop the subscription without dropping the Subscriber database.
  LEAVE_DATABASE = 0  '&H0

  'Drop the subscription and the Subscriber database.
  DROP_DATABASE = 1  '&H1

  'Unregister the subscription without dropping the subscription.
  UNREGISTER_SUBSCRIPTION = 2  '&H2
End Enum

ERRORSOURCE_TYPE

Public Enum ERRORSOURCE_TYPE

  '0 - Invalid source type
  INVALID_SOURCE_TYPE = 0  '&H0

  '1 - SQL Command that caused error
  SQL_COMMAND = 1  '&H1

  '2 - SQL Server Replication ActiveX Control
  REPL_CONTROL = 2  '&H2

  '3 - Operating System
  OPERATING_SYSTEM = 3  '&H3

  '4 - ODBC API
  ODBC_API = 4  '&H4

  '5 - SQL Server
  SQLSERVER_ENGINE = 5  '&H5

  '6 - Net Library
  NET_LIBRARY = 6  '&H6

  '7 - SQL DMO
  SQLDMO = 7  '&H7

  '8 - Merge Replication Provider
  MERGE_PROVIDER = 8  '&H8

  '9 - Merge Process
  MERGE_PROCESS = 9  '&H9

  '10 - Replication Transport
  REPL_TRANSPORT = 10  '&HA

  '11 - Microsoft SQL Server CE
  REPL_SSCE = 11  '&HB

  '12 - Replication OCI
  REPL_OCI = 12  '&HC

  '13 - Replication OLEDB
  REPL_OLEDB = 13  '&HD
End Enum

FILE_TRANSFER_TYPE

Public Enum FILE_TRANSFER_TYPE

  'Apply snapshot from an UNC network share.
  FILETRANSFERUNC = 0  '&H0

  'Download snapshot files via FTP.
  FILETRANSFERFTP = 1  '&H1
End Enum

FILECREATE_OPTION

Public Enum FILECREATE_OPTION

  'Create a new file.
  CREATE_NEW_FILE = 0  '&H0

  'Overwrite existing file.
  OVERWRITE_EXISTING_FILE = 1  '&H1
End Enum

SUBSCRIPTION_PRIORITY_TYPE

Public Enum SUBSCRIPTION_PRIORITY_TYPE

  'This subscription has an assigned priority number.
  GLOBAL_PRIORITY = 1  '&H1

  'This subscription uses the priority number of the Publisher.
  LOCAL_PRIORITY = 2  '&H2
End Enum

SYNCHRONIZATION_TYPE

Public Enum SYNCHRONIZATION_TYPE

  'Initial synchronization is needed by this Subscriber.
  AUTOMATIC = 1  '&H1

  'No initial synchronization is needed.
  NOSYNC = 2  '&H2
End Enum