The DataFlex Pervasive.SQL Driver can be configured to operate in database mode or in non database mode. When running in database mode Pervasive.SQL tables are located by specifying a Pervasive.SQL database name. In non-database mode tables are located by specifying paths to the physical data files.
Database mode can only be used when running on Pervasive.SQL V8.5 or later.
When running in database mode it is possible to access Pervasive.SQL secured databases. One of the main advantages of secured databases is that users no longer need operating system access rights to access Pervasive.SQL data files. Instead all authentication and authorization is handled by the Pervasive transactional database engine.
When using secured databases, access rights can be defined for individual users and tables. Users and access rights are defined in the Pervasive.SQL meta database and are independent of operating system access rights.
When operating in database mode the driver can also concurrently access tables in more than one database, possibly on different servers.