Database Connectivity - Single User Firebird

Database Connectivity options are used to make a connection to the IndySoft Database - which for Single-User clients is installed locally on the same computer as the client:

Database Settings - Database Connectivity - Single-User Firebird

Database Connectivity

Firebird Database Name - This field stores the server and database location of the IndySoft database on your single-user workstation. If you wish to change the default location, browse for the file using the file browse button. The format of the connection string will automatically be set up for you.

Database User I.D. - Enter the Firebird username that should be used for logging in to the Firebird database. Note: this login is different from the user name input from the IndySoft login screen (when logging into the main screen). IndySoft has its own user list maintained in the Profile Manager. This is the Firebird user name that IndySoft will use 'behind the scenes' for connecting to the database. It is suggested that this username be set to the owner of the IndySoft database objects in Firebird. By default, this is 'SYSDBA.'

Database Password - Enter the password used along with the 'Database User ID' above to connect to the IndySoft Firebird database. Note that this password is encrypted when saved locally. By default, this is 'masterkey'.

Show Encrypted Version of Password

Use this button to display a dialog that lists an encrypted version of the currently input password (setting above). This encrypted password is a unique text value that can be used to pass along the password to other IndySoft users - so they can set up their Workstation Setup database connectivity without knowing the actual Firebird database password. When this button is pressed, the following dialog (example) will display.

Note that the encrypted password is copied to the Windows clipboard. Pass along this encrypted password text to other IndySoft users - be sure to remind them to check the 'Encrypt Password' checkbox (described below) when using this password text.

Encrypt Password - Turn on this checkbox if you have pasted in an encrypted password that was created from the 'Show Encrypted Version of Password' button (likely created from a different workstation)

Hour Difference From DB Server - if your client installation runs in a different time zone than the database server, you should enter the hour difference here. This setting is essential for client caching to function correctly. This value should be left at zero if you are in the same time zone as the database server. If you are on the West Coast and the database is on the East Coast, you would be 3 hours behind and should enter -3 into this field. The hour difference should be a positive number if you are ahead of the database server location.

If you want to test the connectivity based on the previously entered options, press the 'Test Connection' button. If your connection is successful, you will see a confirmation. If an error occurs, you will also be alerted.

Optional Database Options
Modifying these settings is typically unnecessary - please do not modify them unless instructed by your System Administrator.

Database Date Format - this field stores the default date format used by your database.

Database Time Format - this field stores the default time format used by your database. (This should almost always be the same as the default database date format)

Database Owner Name - this field stores a database owner name that will be prefixed onto any table name reference from within IndySoft. This field defaults to the standard default owner name.

Database Functions Owner - this field stores a database owner name that will be prefixed onto any function reference from within IndySoft. This field defaults to the standard default owner name.

Database Date Initialization - this field stores an optional initialization string for your database's date format. |