Previous Topic

Next Topic

Book Contents

Book Index

Pervasive.SQL

Admin Component and X$Attrib Table

If you do not have the X$Attrib system table defined on your system, the Admin component will not be able to manage your tables.

The solution is to use an alternate admin config file (pervasive_adm2.cfg) that does not refer to the X$Attrib table. Some attributes of your tables (Default and Case Sensitivity) will not be displayed.

To use this alternate cfg file, go to Options > Config Files. Find the entry for Pervasive and change the Admin Cfg value to pervasive_adm2

This change may also be required if you are running Pervasive.SQL v7, which can misreport column types.

Advanced Query Tool
https://www.querytool.com
© 2023 Cardett Associates Ltd. All rights reserved.