SSCE, COM interface constants for VB.Net / VBScript

SSCE - interface constants

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

library parameters

File NameProgram Files\Microsoft SQL Server Compact Edition\v3.5\sqlceca35.dll
Guid{CE4AACFA-3CFD-4028-B2D9-F272314F07C8}
Enums10

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

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

REPL_EXCHANGE_TYPE

enum, 2 members.
Public Enum REPL_EXCHANGE_TYPE
  UPLOAD = 1  '&H1
  BIDIRECTIONAL = 3  '&H3
End Enum

REPL_VALIDATE_TYPE

enum, 2 members.
Public Enum REPL_VALIDATE_TYPE
  NO_VALIDATION = 0  '&H0
  ROWCOUNT_ONLY = 1  '&H1
End Enum

SNAPSHOT_TRANSFER_TYPE

enum, 2 members.
Public Enum SNAPSHOT_TRANSFER_TYPE
  SNAPSHOT_TRANSFER_UNC = 0  '&H0
  SNAPSHOT_TRANSFER_FTP = 1  '&H1
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

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

RDA_TRACKOPTION

enum, 4 members.
Public Enum RDA_TRACKOPTION
  TRACKINGOFF = 0  '&H0
  TRACKINGON = 1  '&H1
  TRACKINGON_INDEXES = 2  '&H2
  TRACKINGOFF_INDEXES = 3  '&H3
End Enum

RDA_BATCHOPTION

enum, 2 members.
Public Enum RDA_BATCHOPTION
  BATCHINGOFF = 0  '&H0
  BATCHINGON = 1  '&H1
End Enum

REPAIROPTION

enum, 4 members.
Public Enum REPAIROPTION
  DELETECORRUPTED = 0  '&H0
  RECOVERCORRUPTED = 1  '&H1
  RECOVERALLPOSSIBLEROWS = 1  '&H1
  RECOVERALLORFAIL = 2  '&H2
End Enum
WUtils.com