ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> ODBC General Issues >> ODBC Inconsistencies
http://www.istechforum.com/YaBB.pl?num=1175022758

Message started by kevind on 03/27/07 at 12:12:37

Title: ODBC Inconsistencies
Post by kevind on 03/27/07 at 12:12:37

Lynn / Allen:
I noticed some inconsistencies between the current DDF files generated by ODBCDDF and the actual Tables that only you guys can address:

1. column 'IS_NOTE_NOTE' in table ISNOTES data type is not supported in Pervasive.SQL Table Version 7
(that is the microkernal table version, not pervasive version, Version 7 is what 2000i can write as)

2. Table X$Field (generated by ODBCDDF) Index Case Flag Inconsistency.
a. The dictionary index 2 seg 0 indicates case sensitive. = No
Data file index 2 seg 0 indicates case sensitive. = Yes
b. The dictionary index 3 seg 1 indicates case sensitive. = No
Data file index 3 seg 1 indicates case sensitive. = Yes

3. Table Name = X$File
a. The dictionary index 1 seg 0 indicates case sensitive. = No
Data file index 1 seg 0 indicates case sensitive. = Yes