home *** CD-ROM | disk | FTP | other *** search
/ CD Actual Thematic 25: Programming / pc_actual_25.iso / C_C++ / BorlandCompiler / freecommandLinetools.exe / Include / msjetoledb.h < prev    next >
Encoding:
C/C++ Source or Header  |  2000-06-27  |  11.3 KB  |  180 lines
  1. //=======================================================================
  2. // Microsoft JET OLEDB Provider
  3. //
  4. // Copyright Microsoft (c) 1995-9 Microsoft Corporation.
  5. //
  6. // Component: Microsoft JET Database Engine OLEDB Layer 
  7. //
  8. // File: MSJETOLEDB.H
  9. //
  10. // File Comments: This file contains the GUIDS necessary to load the 
  11. //                  Microsoft JET OLEDB Layer for the JET 4.0 database
  12. //                  Engine.
  13. //
  14. //=======================================================================
  15.  
  16. #ifndef MSJETOLEDB_H
  17. #pragma option push -b -a8 -pc -A- /*P_O_Push*/
  18. #define MSJETOLEDB_H
  19.  
  20. // OLE DB Provider
  21. const GUID CLSID_JETOLEDB_3_51                        = {0xdee35060,0x506b,0x11cf,{0xb1,0xaa,0x00,0xaa,0x00,0xb8,0xde,0x95}};
  22. const GUID CLSID_JETOLEDB_4_00                        = {0xdee35070,0x506b,0x11cf,{0xb1,0xaa,0x00,0xaa,0x00,0xb8,0xde,0x95}};
  23.  
  24. // Jet OLEDB Provider-Specific GUIDs
  25. const GUID DBSCHEMA_JETOLEDB_REPLPARTIALFILTERLIST  = {0xe2082df0,0x54ac,0x11d1,{0xbd,0xbb,0x00,0xc0,0x4f,0xb9,0x26,0x75}};
  26. const GUID DBSCHEMA_JETOLEDB_REPLCONFLICTTABLES     = {0xe2082df2,0x54ac,0x11d1,{0xbd,0xbb,0x00,0xc0,0x4f,0xb9,0x26,0x75}};
  27. const GUID DBSCHEMA_JETOLEDB_USERROSTER             = {0x947bb102,0x5d43,0x11d1,{0xbd,0xbf,0x00,0xc0,0x4f,0xb9,0x26,0x75}};
  28. const GUID DBSCHEMA_JETOLEDB_ISAMSTATS              = {0x8703b612,0x5d43,0x11d1,{0xbd,0xbf,0x00,0xc0,0x4f,0xb9,0x26,0x75}};
  29.  
  30. // Jet(Access)-Specific Security Objects
  31. const GUID DBOBJECT_JETOLEDB_FORMS                     = {0xc49c842e,0x9dcb,0x11d1,{0x9f,0x0a,0x00,0xc0,0x4f,0xc2,0xc2,0xe0}};
  32. const GUID DBOBJECT_JETOLEDB_SCRIPTS                 = {0xc49c842f,0x9dcb,0x11d1,{0x9f,0x0a,0x00,0xc0,0x4f,0xc2,0xc2,0xe0}}; // These are Macros in Access
  33. const GUID DBOBJECT_JETOLEDB_REPORTS                 = {0xc49c8430,0x9dcb,0x11d1,{0x9f,0x0a,0x00,0xc0,0x4f,0xc2,0xc2,0xe0}};
  34. const GUID DBOBJECT_JETOLEDB_MODULES                 = {0xc49c8432,0x9dcb,0x11d1,{0x9f,0x0a,0x00,0xc0,0x4f,0xc2,0xc2,0xe0}};
  35.  
  36. // Private Property Set Descriptions
  37. const GUID DBPROPSET_JETOLEDB_ROWSET                = {0xa69de420,0x0025,0x11d0,{0xbc,0x9c,0x00,0xc0,0x4f,0xd7,0x05,0xc2}};
  38. const GUID DBPROPSET_JETOLEDB_SESSION                = {0xb20f6c12,0x9b2a,0x11d0,{0x9e,0xbd,0x00,0xc0,0x4f,0xc2,0xc2,0xe0}};
  39. const GUID DBPROPSET_JETOLEDB_DBINIT                = {0x82cf8156,0x9b40,0x11d0,{0x9e,0xbd,0x00,0xc0,0x4f,0xc2,0xc2,0xe0}};
  40. const GUID DBPROPSET_JETOLEDB_TABLE                    = {0xe64cc5fc,0x9ff2,0x11d0,{0x9e,0xbd,0x00,0xc0,0x4f,0xc2,0xc2,0xe0}};
  41. const GUID DBPROPSET_JETOLEDB_COLUMN                = {0x820bf922,0x6ac8,0x11d1,{0x9f,0x02,0x00,0xc0,0x4f,0xc2,0xc2,0xe0}};
  42. const GUID DBPROPSET_JETOLEDB_TRUSTEE                = {0xc9e19286,0x9b4a,0x11d1,{0x9f,0x0a,0x00,0xc0,0x4f,0xc2,0xc2,0xe0}};
  43.  
  44. // PROPIDs for DBPROPSET_JETOLEDB_ROWSET:
  45. #define DBPROP_JETOLEDB_ODBCPASSTHROUGH                    0xFD    // Is this query a pass-through query
  46. #define DBPROP_JETOLEDB_ODBCPASSTHROUGHCONNECTSTRING    0xF2    // Jet Connect String for pass-through query
  47. #define DBPROP_JETOLEDB_BULKPARTIAL                        0xEF    // Allow partial bulk operations
  48. #define    DBPROP_JETOLEDB_ENABLEFATCURSOR                    0xEE    // Enable "fat cursor" caching
  49. #define DBPROP_JETOLEDB_FATCURSORMAXROWS                0xED    // # of rows to cache in "fat cursor" 
  50. //#define DBPROP_JETOLEDB_3_5_ENABLEIRowsetIndex            0x101    // 3.5 ONLY - enable IRowsetIndex interface for Seek
  51. #define DBPROP_JETOLEDB_STOREDQUERY                        0x102    // Treat command text as stored query name
  52. #define DBPROP_JETOLEDB_VALIDATEONSET                    0xEC    // Check validation rules on SetData (instead of Update)
  53. #define DBPROP_JETOLEDB_LOCKGRANULARITY                    0x107    // Alcatraz Locking Granularity - Row/Page/Default
  54. #define DBPROP_JETOLEDB_BULKNOTRANSACTIONS                0x10C    // Determines if DML bulk operations are transacted
  55. #define DBPROP_JETOLEDB_INCONSISTENT                    0x117    // Equivalent to DAO's dbInconsistent
  56. #define DBPROP_JETOLEDB_PASSTHROUGHBULKOP                0x119    // Equivalent to DAO's ReturnsRecords (inversed)
  57.  
  58. // DBPROPSET_JETOLEDB_ROWSET DBPROP_JETOLEDB_LOCKGRANULARITY Enumeration Values
  59. #define DBPROPVAL_LG_PAGE                                0x01    // Page Locking 
  60. #define DBPROPVAL_LG_ALCATRAZ                            0x02    // Alcatraz Row Locking
  61.  
  62.  
  63. // PROPIDs for DBPROPSET_JETOLEDB_SESSION:
  64. #define DBPROP_JETOLEDB_RECYCLELONGVALUEPAGES            0xF9    // Whether the Jet engine should aggressively reclaim freed after use in BLOBs
  65. #define DBPROP_JETOLEDB_PAGETIMEOUT                        0xEB
  66. #define DBPROP_JETOLEDB_SHAREDASYNCDELAY                0xEA
  67. #define DBPROP_JETOLEDB_EXCLUSIVEASYNCDELAY                0xE9
  68. #define DBPROP_JETOLEDB_LOCKRETRY                        0xE8
  69. #define DBPROP_JETOLEDB_USERCOMMITSYNC                    0xE7
  70. #define DBPROP_JETOLEDB_MAXBUFFERSIZE                    0xE6
  71. #define DBPROP_JETOLEDB_LOCKDELAY                        0xE5
  72. #define DBPROP_JETOLEDB_FLUSHTRANSACTIONTIMEOUT            0xE4
  73. #define DBPROP_JETOLEDB_IMPLICITCOMMITSYNC                0xE3
  74. #define DBPROP_JETOLEDB_MAXLOCKSPERFILE                    0xE2
  75. #define DBPROP_JETOLEDB_ODBCCOMMANDTIMEOUT                0xDB
  76. #define DBPROP_JETOLEDB_RESETISAMSTATS                    0x104    // Determines if the ISAMSTATS schema resets after it returns stats
  77. #define DBPROP_JETOLEDB_CONNECTIONCONTROL                0x108    // Passive Shutdown (to prevent others from opening the database)
  78. #define DBPROP_JETOLEDB_ODBCPARSE                        0x113    // ODBC Parsing
  79. #define DBPROP_JETOLEDB_PAGELOCKSTOTABLELOCK            0x114    // # of pages locked in a transaction before jet tries to promote to excl. table lock
  80. #define DBPROP_JETOLEDB_SANDBOX                            0x115    
  81. #define DBPROP_JETOLEDB_TXNCOMMITMODE                    0x116    // Mode to be used when committing transactions
  82.  
  83. // DBPROPSET_JETOLEDB_SESSION DBPROP_JETOLEDB_CONNECTIONCONTROL Enumeration Values
  84. #define DBPROPVAL_JCC_PASSIVESHUTDOWN                    0x01    // prevent others from opening the database
  85. #define DBPROPVAL_JCC_NORMAL                            0x02    // allow others to open the database
  86.  
  87. // DBPROPSET_JETOLEDB_SESSION DBPROP_JETOLEDB_TXNCOMMITMODE Enumeration Values
  88. #define DBPROPVAL_JETOLEDB_TCM_FLUSH                    0x01    // Synchronously commit transactions to disk
  89.  
  90. // PROPIDs for DBPROPSET_JETOLEDB_DBINIT:
  91. #define DBPROP_JETOLEDB_REGPATH                            0xFB    // Path to Jet Registry entries
  92. #define DBPROP_JETOLEDB_SYSDBPATH                        0xFA    // Full Path to System Database
  93. #define DBPROP_JETOLEDB_DATABASEPASSWORD                0x100    // Password for Database 
  94. #define DBPROP_JETOLEDB_ENGINE                            0x103    // Enumeration of Jet Engine/ISAM type/version
  95. #define DBPROP_JETOLEDB_DATABASELOCKMODE                0x106    // Locking Granularity Scheme ("Old"/"Alcatraz" mode)
  96. #define DBPROP_JETOLEDB_GLOBALBULKPARTIAL                0x109    // Database Default Partial/No Partial Behavior
  97. #define DBPROP_JETOLEDB_GLOBALBULKNOTRANSACTIONS        0x10B    // Determines if DML bulk operations are transacted
  98. #define DBPROP_JETOLEDB_NEWDATABASEPASSWORD                0x10D    // Used to set new database password in IDBDataSourceAdmin::ModifyDataSource
  99. #define DBPROP_JETOLEDB_CREATESYSTEMDATABASE            0x10E    // Used on IDBDataSourceAdmin::CreateDataSource to create a system database
  100. #define DBPROP_JETOLEDB_ENCRYPTDATABASE                    0x10F    // Used on CreateDatasource, Compact to determine if new database is encrypted
  101. #define DBPROP_JETOLEDB_COMPACT_DONTCOPYLOCALE            0x110    // Don't copy per-column locale information to the compact target
  102. #define DBPROP_JETOLEDB_COMPACT_NOREPAIRREPLICAS        0x112    // Don't try to repair damaged replica databases when compacting
  103. #define DBPROP_JETOLEDB_SFP                                0x118    
  104. #define DBPROP_JETOLEDB_COMPACTFREESPACESIZE            0x11A    // How much free space would be reclaimed if the db were compacted
  105.  
  106. // DBPROP_JETOLEDB_GLOBALBULKPARTIAL/DBPROP_JETOLEDB_BULKPARTIAL Enumeration Values
  107. #define DBPROPVAL_BP_DEFAULT                            0x00    // Default (only valid for DBPROP_JETOLEDB_BULKPARTIAL)
  108. #define DBPROPVAL_BP_PARTIAL                            0x01    // Use partial updates (like Access)
  109. #define DBPROPVAL_BP_NOPARTIAL                            0x02    // Use No Partial Behavior (all or nothing)
  110.  
  111. // DBPROP_JETOLEDB_GLOBALNOTRANSACTIONS/DBPROP_JETOLEDB_BULKNOTRANSACTIONS Enumeration Values
  112. #define DBPROPVAL_BT_DEFAULT                            0x00    // Default (only valid for DBPROP_JETOLEDB_NOTRANSACTIONS)
  113. #define DBPROPVAL_BT_NOBULKTRANSACTIONS                    0x01    // Don't transact bulk operations
  114. #define DBPROPVAL_BT_BULKTRANSACTIONS                    0x02    // Transact bulk operations
  115.  
  116. // DBPROPSET_JETOLEDB_DBINIT DBPROP_JETOLEDB_ENGINE Enumeration Values
  117. #define JETDBENGINETYPE_UNKNOWN                            0x00    // ISAM Type Unknown/ N/A
  118. #define JETDBENGINETYPE_JET10                            0x01
  119. #define JETDBENGINETYPE_JET11                            0x02
  120. #define JETDBENGINETYPE_JET2X                            0x03
  121. #define JETDBENGINETYPE_JET3X                            0x04
  122. #define JETDBENGINETYPE_JET4X                            0x05
  123. #define JETDBENGINETYPE_DBASE3                            0x10
  124. #define JETDBENGINETYPE_DBASE4                            0x11
  125. #define JETDBENGINETYPE_DBASE5                            0x12
  126. #define JETDBENGINETYPE_EXCEL30                            0x20
  127. #define JETDBENGINETYPE_EXCEL40                            0x21
  128. #define JETDBENGINETYPE_EXCEL50                            0x22
  129. #define JETDBENGINETYPE_EXCEL80                            0x23
  130. #define JETDBENGINETYPE_EXCEL90                            0x24
  131. #define JETDBENGINETYPE_EXCHANGE4                        0x30
  132. #define JETDBENGINETYPE_LOTUSWK1                        0x40
  133. #define JETDBENGINETYPE_LOTUSWK3                        0x41
  134. #define JETDBENGINETYPE_LOTUSWK4                        0x42
  135. #define JETDBENGINETYPE_PARADOX3X                        0x50
  136. #define JETDBENGINETYPE_PARADOX4X                        0x51
  137. #define JETDBENGINETYPE_PARADOX5X                        0x52
  138. #define JETDBENGINETYPE_PARADOX7X                        0x53
  139. #define JETDBENGINETYPE_TEXT1X                            0x60
  140. #define JETDBENGINETYPE_HTML1X                            0x70
  141.  
  142. // DBPROPSET_JETOLEDB_DBINIT DBPROP_JETOLEDB_DATABASELOCKMODE Enumeration Values
  143. #define DBPROPVAL_DL_OLDMODE                            0x00    // Original Jet Database Locking Scheme
  144. #define DBPROPVAL_DL_ALCATRAZ                            0x01    // Alcatraz Technology - enables row-level locking
  145.  
  146. // PROPIDs for DBPROPSET_JETOLEDB_TABLE:
  147. #define DBPROP_JETOLEDB_LINK                            0xF7    // Is this table really a link?
  148. #define DBPROP_JETOLEDB_LINKEXCLUSIVE                    0xF6    // Should this link be opened exclusively on the remote database
  149. #define DBPROP_JETOLEDB_LINKDATASOURCE                    0xF5    // Remote data source to which to link
  150. #define DBPROP_JETOLEDB_LINKPROVIDERSTRING                0xF4    // Jet Provider string to be used to connect to the remote data source
  151. #define DBPROP_JETOLEDB_LINKREMOTETABLE                    0xF3    // remote table name of the link
  152. #define DBPROP_JETOLEDB_LINKCACHE_AUTHINFO                0xF0    // Should authentication information for this link be cached in the database?
  153. #define    DBPROP_JETOLEDB_VALIDATIONRULE                    0xD8    // Table Validation Rule
  154. #define    DBPROP_JETOLEDB_VALIDATIONTEXT                    0xD7    // Access Text to display when validation rule is not met
  155. #define    DBPROP_JETOLEDB_HIDDENINACCESS                    0x10A    // Determines if a table shows up as "hidden" in MS Access
  156.  
  157. // PROPIDs for DBPROPSET_JETOLEDB_COLUMN:
  158. #define    DBPROP_JETOLEDB_COL_HYPERLINK                    0xE1    // Hyperlink flag - use on "LongText" fields only
  159. #define    DBPROP_JETOLEDB_COL_ALLOWZEROLENGTH                0xE0    // Allow Zero Length Strings 
  160. #define    DBPROP_JETOLEDB_COL_COMPRESSED                    0xDF    // Compressed Text Columns (Red 4.x only)
  161. #define    DBPROP_JETOLEDB_COL_ONELVPERPAGE                0xDE    // Put more than one BLOB on a page (size allowing)?
  162. #define    DBPROP_JETOLEDB_COL_AUTOGENERATE                0xDD    // Autogenerate the value (GUID columns only)
  163. #define    DBPROP_JETOLEDB_COL_IISAMNOTLAST                0xDC    // used to tell the IISAM you intend to add more columns after this one
  164. #define    DBPROP_JETOLEDB_COL_VALIDATIONRULE                0xDA    // Column validation rule
  165. #define    DBPROP_JETOLEDB_COL_VALIDATIONTEXT                0xD9    // column validation text to display when validation rule is not met
  166.  
  167. // PROPIDs for DBPROPSET_COLUMN:
  168. #ifndef DBPROP_COL_SEED
  169. #define DBPROP_COL_SEED                                    0x11AL    
  170. #endif // DBPROP_COL_SEED
  171.  
  172. #ifndef DBPROP_COL_INCREMENT
  173. #define DBPROP_COL_INCREMENT                            0x11BL
  174. #endif // DBPROP_COL_INCREMENT
  175.  
  176. // PROPIDs for DBPROPSET_JETOLEDB_TRUSTEE:
  177. #define    DBPROP_JETOLEDB_TRUSTEE_PIN                        0x105    // Jet User pin (Username + Pin --> SID)
  178.  
  179. #pragma option pop /*P_O_Pop*/
  180. #endif //MSJETOLEDB_H