Skip to content

Pervasive.SQL Database Concepts

A database in Pervasive.SQL consists of:

  • Data tables (BTR files)
  • Meta data with structural information (FILE.DDF, FIELD.DDF, INDEX.DDF)
  • Meta data with authentication information (USERS.DDF and RIGHTS.DDF)

Databases must be set up using Pervasive Control Center. During setup, the folder on the server where the data files will reside must be specified.

Databases can be secured or unsecured. Security of a database can be switched on and off in Pervasive Control Center. When security is on, users and user rights can be defined for the database.

Note: Pervasive.SQL supplies different security models to choose from (Classic/Mixed/Database security). Depending on the chosen model, security setup (users and rights) will be different. Refer to the Pervasive documentation for further information.

Once a database is set up, it can be accessed by specifying the name of the database in a URI (Uniform Resource Indicator).

A URI looks like this:

btrv://user@host/database?table=tablename&pwd=passwd

Where:

  • user/passwd: The user name and password as defined for the PSQL database
  • host: The server name of the PSQL server
  • database: The name of the database that needs to be accessed
  • table: The table in the database to open

Example

btrv://psquser@MyPervasiveServer/ORDER?table=SALESP&pwd=secret

This URI shows how to open the table SALESP in the database ORDER on the server MyPervasiveServer. The table can only be accessed if the user psqluser has been assigned sufficient access rights to the database and/or table.

Refer to the Pervasive documentation for further information about URIs.