MSAdodcLib, COM interface constants for VB.Net / VBScript

MSAdodcLib - interface constants

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

library parameters

File NameWINDOWS\system32\MSADODC.OCX
Guid{67397AA1-7FB1-11D0-B148-00A0C922E820}
Enums9

BOFActionEnum

enum, 2 members.
  'BOFAction constants
Public Enum BOFActionEnum

  'Force MoveFirst on BOF
  adDoMoveFirst = 0  '&H0

  'Stay at BOF on BOF
  adStayBOF = 1  '&H1
End Enum

EOFActionEnum

enum, 3 members.
  'EOFAction constants
Public Enum EOFActionEnum

  'Force MoveLast on EOF
  adDoMoveLast = 0  '&H0

  'Stay at EOF on EOF
  adStayEOF = 1  '&H1

  'Force AddNew mode on EOF
  adDoAddNew = 2  '&H2
End Enum

AppearanceEnum

enum, 2 members.
  'Appearance constants
Public Enum AppearanceEnum

  'Flat appearance
  adFlatBevel = 0  '&H0

  '3D appearance
  ad3DBevel = 1  '&H1
End Enum

OrientationEnum

enum, 2 members.
  'Orientation constants
Public Enum OrientationEnum

  'Orient horizontally
  adHorizontal = 0  '&H0

  'Orient vertically
  adVertical = 1  '&H1
End Enum

ConnectStringTypeEnum

enum, 4 members.
  'ConnectStringType constants
Public Enum ConnectStringTypeEnum

  'Unknown type connection string
  adConnectTypeUnknown = 0  '&H0

  'Use OLEDB-style connection string
  adConnectTypeOledb = 1  '&H1

  'Use OLEDB file-type connection string
  adConnectTypeOledbFile = 2  '&H2

  'User ODBC-style connection string with ODBC OLEDB Provider
  adConnectTypeOdbc = 3  '&H3
End Enum

AdodcErrorEnum

enum, 7 members.
  'ADODC Error Constants
Public Enum AdodcErrorEnum

  'Error getting ADODC erro info
  ERRADODC_ERRORINFO = 25020  '&H61BC

  'Error setting the Mode property
  ERRADODC_SETMODE = 25021  '&H61BD

  'Error setting the ConnectionTimeout property
  ERRADODC_SETCONNECTTIMEOUT = 25022  '&H61BE

  'Error setting the CursorLocation property
  ERRADODC_SETCURSORLOCATION = 25023  '&H61BF

  'Error setting the CommandTimeout property
  ERRADODC_SETCOMMANDTIMEOUT = 25024  '&H61C0

  'Error setting the CacheSize property
  ERRADODC_SETCACHESIZE = 25025  '&H61C1

  'Error setting the MaxRecords property
  ERRADODC_SETMAXRECORDS = 25026  '&H61C2
End Enum

CursorTypeEnum

enum, 3 members.
  'CursorType constants
Public Enum CursorTypeEnum

  'Keyset CursorType
  adOpenKeyset = 1  '&H1

  'Dynamic CursorType
  adOpenDynamic = 2  '&H2

  'Static CursorType
  adOpenStatic = 3  '&H3
End Enum

CursorLocationEnum

enum, 2 members.
  'CursorLocation constants
Public Enum CursorLocationEnum

  'Use server cursors
  adUseServer = 2  '&H2

  'Use client cursors
  adUseClient = 3  '&H3
End Enum

CommandTypeEnum

enum, 4 members.
  'CommandTypeConstants
Public Enum CommandTypeEnum

  'Unknown CommandType
  adCmdUnknown = 8  '&H8

  'Text CommandType
  adCmdText = 1  '&H1

  'Table CommandType
  adCmdTable = 2  '&H2

  'StoredProc CommandType
  adCmdStoredProc = 4  '&H4
End Enum
WUtils.com