WUtils.com

SQLDISTXLib, COM interface constants for VB.Net / VBScript

SQLDISTXLib - interface constants

     This page contains simple VBA include for the SQLDISTXLib COM library.

library parameters

File NameProgram Files\Microsoft SQL Server\100\COM\sqldistx.dll
Guid{4AC4D38E-B5C0-4224-B98D-946D58684F39}
Enums15

STATUS_RETURN_CODE

enum, 2 members.
Public Enum STATUS_RETURN_CODE

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

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

SECURITY_TYPE

enum, 3 members.
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

enum, 9 members.
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

enum, 4 members.
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

NETWORK_TYPE

enum, 3 members.
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

DBADDOPTION

enum, 5 members.
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

enum, 2 members.
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

enum, 3 members.
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

enum, 14 members.
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

enum, 2 members.
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

enum, 2 members.
Public Enum FILECREATE_OPTION

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

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

REPL_FAILOVER_MODE

enum, 3 members.
Public Enum REPL_FAILOVER_MODE

  'No failover
  FAILOVER_NONE = 0  '&H0

  'Immediate updating
  FAILOVER_IMMEDIATE = 1  '&H1

  'Queued updating
  FAILOVER_QUEUED = 2  '&H2
End Enum

SYNCHRONIZATION_TYPE

enum, 2 members.
Public Enum SYNCHRONIZATION_TYPE

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

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

SUBSCRIPTION_UPDATE_MODE

enum, 4 members.
Public Enum SUBSCRIPTION_UPDATE_MODE

  'Read Only Mode
  UPDMODE_READONLY = 0  '&H0

  'Sync Tran Mode
  UPDMODE_SYNCTRAN = 1  '&H1

  'Queued Tran Mode
  UPDMODE_QUEUEDTRAN = 2  '&H2

  'Fail Over Mode
  UPDMODE_FAILOVER = 3  '&H3
End Enum

REPLRPC_SECURITY_TYPE

enum, 2 members.
Public Enum REPLRPC_SECURITY_TYPE

  'Use dynamic RPC connection(custom login) to the Publisher.
  RPC_STANDARD_MODE = 0  '&H0

  'Use static RPC connection(sysservers info) to the Publisher.
  RPC_STATIC_MODE = 2  '&H2
End Enum
WUtils.com