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