I was very happy at first when I was finally able to see my databases in PCC and get DSNs for them, but after I got a chance to look at it in greater detail, very little of it is actually working. Fewer than half of the tables are accessible.
Patient & Daysheet, the two largest tables which are the roots of the relational queries used most often, are missing in action. When I try to open them in PCC, I get either of the following errors:
1. [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The Btrieve file directory is invalid(Btrieve Error 35)
2. [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The MicroKernal cannot find the specified file(Btrieve Error 12)
3. Or it may come up without an error, but with the grid empty and displaying the message: “No data available for display”.
If I try to bring up the properties I get a different error: a dialog comes up titled “Error” with the message “1: Failed”, followed by another dialog also titled “Error” which says, “Unexpected Error Occurred: NullPointerException”. Alternately, the second dialog my just say “Unknown Error: -19”.
In DDFBuilder most of the tables don#%92t come up at all. The few that do loose their field names and most of their fields. I can#%92t see Patient or Daysheet in the list. If I click on any of the few tables that do show up I get the warning: “Errors found in the original table defintion. See Definition Errors View for more information.” The Definition Errors are subtle variations on the following error: “Column: unnamed_3 DDFBLDR-6: Undefined bytes in table definition. Unknown column added.”
All of the few remaining fields are titled unnamed_# with the # being a number of seven or less, while these tables typically have over a hundred fields.
Finally, when I first open a database I get the warning: “Btrieve files with pre 6.X file formats were found in "D:\pathlist". In order to operate on these files in DDFBuilder, you must rebuild the files to 6.X or greater file format.” When I look in the DDFBuilder log file the files it complained about were four small tables that are hardly ever used.
So basically nothing in these DDFs work in PCC or DDFBuilder. They work fine in Crystal Reports v8.5, but that is the only place I can get them to work, Crystal version XI will not open the DDFs either, nor will VS2005.