home *** CD-ROM | disk | FTP | other *** search
/ CD-ROM Magazine 19 / CDROM19.iso / PBODB040.INI < prev    next >
INI File  |  1996-03-27  |  48KB  |  1,137 lines
  1. ; *******************************************************************
  2. ; Connect options
  3. ;     PBTRACE - ON : set ODBC connect option for trace on,  all odbc 
  4. ;                    are written to the file specified by the
  5. ;                    PBTraceFile entry (only use for debugging since
  6. ;                    tracing adversely affect performance)
  7. ;               OFF: do notset ODBC connect option for trace on            
  8. ; *******************************************************************
  9. [PBCONNECTOPTIONS]
  10. PBTrace='OFF'
  11. PBTraceFile='c:\PBSQL.LOG'
  12. ; ********************************************************************
  13. ; DBMS Driver / DBMS Settings see comments at end of file
  14. ; 
  15. ; ********************************************************************
  16.  
  17. ;[WATCOM SQL 3.0]
  18. [WATCOM SQL WSQLODBC]
  19. PBSyntax='WATCOM_SYNTAX'
  20. PBDateTime='STANDARD_DATETIME'
  21. PBFunctions='WATCOM_FUNCTIONS'
  22. DelimitIdentifier='YES'
  23. PBDateTimeInvalidInSearch='NO'
  24. PBTimeInvalidInSearch='YES'
  25. PBQualifierIsOwner='NO'
  26. PBSpecialDataTypes='WATCOM_SPECIALDATATYPES'
  27. PBSystemOwner='sys'
  28.  
  29. ;[WATCOM SQL WOD40W]
  30. [WATCOM SQL]
  31. PBSyntax='WATCOM40_SYNTAX'
  32. PBDateTime='STANDARD_DATETIME'
  33. PBFunctions='WATCOM_FUNCTIONS'
  34. DelimitIdentifier='YES'
  35. PBDateTimeInvalidInSearch='NO'
  36. PBTimeInvalidInSearch='YES'
  37. PBQualifierIsOwner='NO'
  38. PBSpecialDataTypes='WATCOM_SPECIALDATATYPES'
  39. PBSystemOwner='sys'
  40. ForeignKeyDeleteRule='Disallow if Dependent Rows Exist (RESTRICT),Delete any Dependent Rows (CASCADE),Set Dependent Columns to NULL (SET NULL)'
  41.  
  42. ; Microsoft driver for Access
  43. [Access]
  44. PBSyntax='ACCESS_SYNTAX'
  45. PBConCatIndex='YES'
  46. PBFileManager='YES'
  47. PBNoRequiredFields='YES'
  48. PBTrimCharColumns='YES'
  49. PBTrimCatCharColumns='YES'
  50. PBDateTime='DEFAULT_DATETIME'
  51. PBSpecialDataTypes='ACCESS_SPECIALDATATYPES'
  52.  
  53. ; Q+E driver for Btrieve
  54. [BTRIEVE]
  55. PBSyntax='QE_BTRIEVE_SYNTAX'
  56. PBConCatIndex='YES'
  57. PBFileManager='YES'
  58. PBNoRequiredFields='YES'
  59. PBTrimCharColumns='YES'
  60. PBTrimCatCharColumns='YES'
  61. PBDateTime='DEFAULT_DATETIME'
  62. PBFunctions='QE_BTRIEVE_FUNCTIONS'
  63. PBSpecialDataTypes='QE_BTRIEVE_SPECIALDATATYPES'
  64. DelimitIdentifier='NO'
  65.  
  66. ; Microsoft driver for Btrieve
  67. [BTRIEVE SIMBA]
  68. PBSyntax='MS_BTRIEVE_SYNTAX'
  69. PBConCatIndex='YES'
  70. PBFileManager='YES'
  71. PBNoRequiredFields='YES'
  72. PBTrimCharColumns='YES'
  73. PBTrimCatCharColumns='YES'
  74. PBDateTime='STANDARD_DATETIME'
  75. PBFunctions='MS_BTRIEVE_FUNCTIONS'
  76.  
  77. ; Microsoft driver for Btrieve 2.0 pack
  78. [BTRIEVE ODBCJT16]
  79. PBSyntax='MS_BTRIEVE_SYNTAX'
  80. PBConCatIndex='YES'
  81. PBFileManager='YES'
  82. PBNoRequiredFields='YES'
  83. PBTrimCharColumns='YES'
  84. PBTrimCatCharColumns='YES'
  85. PBDateTime='STANDARD_DATETIME'
  86. PBFunctions='MS_BTRIEVE_FUNCTIONS'
  87.  
  88. [BTRIEVE ODBCJT32]
  89. PBSyntax='MS_BTRIEVE_SYNTAX'
  90. PBConCatIndex='YES'
  91. PBFileManager='YES'
  92. PBNoRequiredFields='YES'
  93. PBTrimCharColumns='YES'
  94. PBTrimCatCharColumns='YES'
  95. PBDateTime='STANDARD_DATETIME'
  96. PBFunctions='MS_BTRIEVE_FUNCTIONS'
  97.  
  98. ; CA-IDMS/DB driver
  99. [CA-IDMS/DB]
  100. PBCatalogOwner='PBCatalogOwner-schema-name'
  101. PBSyntax='IDMS_SYNTAX'
  102. PBDateTime='DEFAULT_DATETIME'
  103. PBFunctions='IDMS_FUNCTIONS'
  104. DelimitIdentifier='YES'
  105. PBSpecialDataTypes='IDMS_SPECIALDATATYPES'
  106. PBEscapeChar='NO'
  107. PBNonStdChars='-'
  108.  
  109. ; Q+E driver for DBASE
  110. [DBASE]
  111. PBSyntax='DBASE_SYNTAX'
  112. PBConCatIndex='NO'
  113. PBFileManager='YES'
  114. PBNoRequiredFields='YES'
  115. PBTrimCharColumns='YES'
  116. PBTrimCatCharColumns='YES'
  117. DelimitIdentifier='NO'
  118. PBSpecialDataTypes='DBASE_SPECIALDATATYPES'
  119. PBDateTime='DEFAULT_DATETIME'
  120.  
  121. ; Q+E 2.0 ODBC driver for DBASE 4 
  122. [dBase V]
  123. PBSyntax='DBASE_SYNTAX'
  124. PBConCatIndex='NO'
  125. PBFileManager='YES'
  126. PBNoRequiredFields='YES'
  127. PBTrimCharColumns='YES'
  128. PBTrimCatCharColumns='YES'
  129. DelimitIdentifier='NO'
  130. PBSpecialDataTypes='DBASE_SPECIALDATATYPES'
  131. PBDateTime='DEFAULT_DATETIME'
  132.  
  133.  
  134. ; Q+E 2.0 ODBC driver for DBASE 4 
  135. [dBase IV]
  136. PBSyntax='DBASE_SYNTAX'
  137. PBConCatIndex='NO'
  138. PBFileManager='YES'
  139. PBNoRequiredFields='YES'
  140. PBTrimCharColumns='YES'
  141. PBTrimCatCharColumns='YES'
  142. DelimitIdentifier='NO'
  143. PBSpecialDataTypes='DBASE_SPECIALDATATYPES'
  144. PBDateTime='DEFAULT_DATETIME'
  145.  
  146. ; Q+E 2.0 ODBC driver for DBASE 3 
  147. [dBase III]
  148. PBSyntax='DBASE_SYNTAX'
  149. PBConCatIndex='NO'
  150. PBFileManager='YES'
  151. PBNoRequiredFields='YES'
  152. PBTrimCharColumns='YES'
  153. PBTrimCatCharColumns='YES'
  154. DelimitIdentifier='NO'
  155. PBSpecialDataTypes='DBASE_SPECIALDATATYPES'
  156. PBDateTime='DEFAULT_DATETIME'
  157.  
  158. ; Q+E 2.0 ODBC driver for DBASE 2 
  159. [dBase II]
  160. PBSyntax='DBASE_SYNTAX'
  161. PBConCatIndex='NO'
  162. PBFileManager='YES'
  163. PBNoRequiredFields='YES'
  164. PBTrimCharColumns='YES'
  165. PBTrimCatCharColumns='YES'
  166. DelimitIdentifier='NO'
  167. PBSpecialDataTypes='DBASE_SPECIALDATATYPES'
  168. PBDateTime='DEFAULT_DATETIME'
  169.  
  170. ; Microsoft driver for DBASEIII
  171. [DBASE3]
  172. PBSyntax='DBASE_SYNTAX'
  173. PBConCatIndex='NO'
  174. PBFileManager='YES'
  175. PBNoRequiredFields='YES'
  176. PBTrimCharColumns='YES'
  177. PBTrimCatCharColumns='YES'
  178.  
  179. ; Microsoft driver for DBASEIV
  180. [DBASE4]
  181. PBSyntax='DBASE_SYNTAX'
  182. PBConCatIndex='NO'
  183. PBFileManager='YES'
  184. PBNoRequiredFields='YES'
  185. PBTrimCharColumns='YES'
  186. PBTrimCatCharColumns='YES'
  187.  
  188. ; Microsoft driver for DBASE  2.0 pack
  189. [DBASE ODBCJT16]
  190. PBSyntax='DBASE_SYNTAX'
  191. PBConCatIndex='NO'
  192. PBFileManager='YES'
  193. PBNoRequiredFields='YES'
  194. PBTrimCharColumns='YES'
  195. PBTrimCatCharColumns='YES'
  196.  
  197. [DBASE ODBCJT32]
  198. PBSyntax='DBASE_SYNTAX'
  199. PBConCatIndex='NO'
  200. PBFileManager='YES'
  201. PBNoRequiredFields='YES'
  202. PBTrimCharColumns='YES'
  203. PBTrimCatCharColumns='YES'
  204.  
  205. ; Q+E Driver for DB2/2  and IBM CAE 1.2 DB2CLIW
  206. [DB2/2]
  207. PBCatalogOwner='PBCATOWN'
  208. PBSyntax='DB22_SYNTAX'
  209. PBDateTime='ISO_DATETIME'
  210. PBFunctions='DB22_FUNCTIONS'
  211. DelimitIdentifier='YES'
  212. PBSystemOwner='SYSIBM'
  213. IdentifierCase=3
  214. PBSupportBindSelect='NO'
  215. PBSupportBindUpdate='NO'
  216. PBSupportDBBind='NO'
  217.  
  218.  
  219. ; For EDA/SQL, build the PB catalog with ISQL then delete PBNoCatalog entry
  220. ; and replace it with PBCatalogOwner=owner.  
  221. [EDASERVE]
  222. PBNoCatalog='YES'
  223. PBDateTime='ISO_DATETIME'
  224.  
  225. ; Microsoft driver for EXCEL
  226. [EXCEL]
  227. PBSyntax='Excel_SYNTAX'
  228. PBFileManager='YES'
  229. PBNoRequiredFields='YES'
  230. PBNoCatalog='YES'
  231. PBSupportBindSelect='NO'
  232. PBSupportBindUpdate='NO'
  233. PBSupportDBBind='NO'
  234.  
  235. ; Microsoft driver for Foxpro
  236. [FoxPro 2.5]
  237. PBConCatIndex='NO'
  238. PBFileManager='YES'
  239. PBNoRequiredFields='YES'
  240. PBSyntax='FOXP25_SYNTAX'
  241. PBTrimCharColumns='YES'
  242. PBTrimCatCharColumns='YES'
  243.  
  244. ; Microsoft driver for Foxpro 2.0 pack
  245. [FOXPRO ODBCJT16]
  246. PBConCatIndex='NO'
  247. PBFileManager='YES'
  248. PBNoRequiredFields='YES'
  249. PBSyntax='FOXP25_SYNTAX'
  250. PBTrimCharColumns='YES'
  251. PBTrimCatCharColumns='YES'
  252.  
  253. [FOXPRO ODBCJT32]
  254. PBConCatIndex='NO'
  255. PBFileManager='YES'
  256. PBNoRequiredFields='YES'
  257. PBSyntax='FOXP25_SYNTAX'
  258. PBTrimCharColumns='YES'
  259. PBTrimCatCharColumns='YES'
  260.  
  261. ;Intersolve foxpro 2.5
  262. [FOXPRO]
  263. PBSyntax='FOXP25_SYNTAX'
  264. PBConCatIndex='NO'
  265. PBFileManager='YES'
  266. PBNoRequiredFields='YES'
  267. PBTrimCharColumns='YES'
  268. PBTrimCatCharColumns='YES'
  269. DelimitIdentifier='NO'
  270.  
  271. ;Intersolve foxbase
  272. [FOXBASE]
  273. PBSyntax='FOXP25_SYNTAX'
  274. PBConCatIndex='NO'
  275. PBFileManager='YES'
  276. PBNoRequiredFields='YES'
  277. PBTrimCharColumns='YES'
  278. PBTrimCatCharColumns='YES'
  279. DelimitIdentifier='NO'
  280.  
  281. ; Q+E driver for Informix 
  282. [INFORMIX]
  283. PBSpecialDataTypes='INFORMIX_SPECIALDATATYPES'
  284.  
  285. ; Q+E driver for Ingres
  286. [INGRES QEING03]
  287. PBSyntax='INGRES_SYNTAX'
  288. PBDateTime='DEFAULT_DATETIME'
  289. PBFunctions='DEFAULT_FUNCTIONS'
  290. PBDateTimeInvalidInSearch='YES'
  291. PBTimeInvalidInSearch='YES'
  292. DelimitIdentifier='NO'
  293. PBQualifierIsOwner='NO'
  294. PBSystemOwner='$ingres'
  295. PBCatalogOwner='ingres'
  296.  
  297. ; Ingres (Page Ahead) driver for Ingres
  298. [INGRES]
  299. PBSyntax='INGRES_SYNTAX'
  300. PBDateTime='DEFAULT_DATETIME'
  301. PBFunctions='DEFAULT_FUNCTIONS'
  302. PBDateTimeInvalidInSearch='YES'
  303. PBTimeInvalidInSearch='YES'
  304. DelimitIdentifier='NO'
  305. PBQualifierIsOwner='NO'
  306. PBSystemOwner='$ingres'
  307. PBCatalogOwner='ingres'
  308.  
  309. [Microsoft SQL Server]
  310. PBCatalogOwner='dbo'
  311. PBSyntax='SYBASE_SYNTAX'
  312. PBDateTime='DEFAULT_DATETIME'
  313. PBFunctions='SYBASE_FUNCTIONS'
  314. PBSpecialDataTypes='SYBASE_SPECIALDATATYPES'
  315. PBObjectIDs='YES'
  316. PBMaxBlobSize='2147483647'
  317. PBMaxTextSize='32767'
  318. PBDWDynamic='NO'
  319.  
  320. ; PB Q+E driver for NetWareSQL  
  321. [Netware SQL]
  322. PBSyntax='QE_NETWARE_SYNTAX'
  323. PBConCatIndex='YES'
  324. PBNoRequiredFields='YES'
  325. PBTrimCharCo