19.10. InterBase Previous topic Parent topic Child topic Next topic

In DBSource, driver name is “InterBase”, and a required option is database, which specifies the path name of the file where the database is to be stored. DBUsername is the InterBase user name, and DBAuth is the password for the InterBase user.
To create a new database, see goodies/ansiCreate.sql for more information.
Be careful to review the InterBase specific notes in goodies/ansiCreate.sql. Some SQL clauses require a couple of little tweaks. Note that, for example, the name of the password column is PASS_WORD. PASSWORD is a reserved word in InterBase.
Configure your SQL clause like this:
DBSource    dbi:InterBase:database=/path/to/your/database.gdb
DBUsername  username
DBAuth      password
AuthSelect  select PASS_WORD from SUBSCRIBERS where USERNAME=%0