Database Connection Settings
Reference Contents > Preferences > Database Connection Settings
This window allows you to modify the Extras/Logon.db database containing logon settings for users.
You can gain access to these settings from the Logon window or the File — Preferences –Database Logon Settings menu item, or from the File — Advanced — Create New Database and Copy Data window.
|
Field |
Description |
|---|---|
|
Company full name |
The connection is associated with a full company name made up or the License Name and a Suffix. Select the full company name to view or modify the database connection settings. |
|
Company license name |
Select the license name for the database connection. Only company names you are licensed to use are available. |
|
Suffix |
A suffix can be added to the licensed company name (e.g. Ltd., Inc, of TEST DATA). The combination of the company name and suffix will identify the Logon to users. |
|
Button |
Action |
|---|---|
|
Add New |
Add a new connection/database. It must be a unique license name and suffix combination. All settings for the new connection will be copied from the currently selected one. |
|
Delete |
Click to delete the settings for the currently selected Company. |
|
Revert |
Click to revert to the previously saved condition. |
|
Save |
Click to save any changes you have made. |
The window has 2 tab panes.
Basic
Basic logon parameters.
There can be any number of these setting each being given a unique extended company name which is used for user selection, built up from license company name and the suffix you apply, such as “My Company Inc.” or “My Company PLAY DATA”. The Company license name options comes from the Extras/Caliach.inf license file. You then choose the DBMS that is to be used and this determines what other parameters are required. SQLite simply requires a path to the database (note on MacOSX this is the absolute POSIX-style path) and nothing more. MySQL and PostgreSQL require a Host and Port for TCP connection, a Database name, and a Username and Password which ascribes internal database privileges for the connection (not to be confused with the program User ID and Password).
|
Field |
Description |
|---|---|
|
Direct Path Subfolder |
An optional folder path inside the Terminal Settings optServerFolder for this database. When this company is logged onto, the combined path will be used to locate supporting files: Extras, Custom, ProgUser.db, ProgSyst.db, etc.. |
|
Resulting Direct Path |
When this company is logged onto, this combined path will be used to locate supporting files: Extras, Custom, ProgUser.db, ProgSyst.db, etc.. |
|
Database management system |
Select the Database Engine you propose to use. |
|
Host |
Database file path for SQLite (e.g. F:DataMyDataFalie.db or a partial path which gets prefixed with optHostPathRoot Terminal option) or Host under server-based DBMSs (e.g. localhost or 192.168.2.100). |
|
SQLite Mac or Linux filepath |
Database file full path for SQLite only when used by a Mac or Linux client or a partial path which gets prefixed with optHostPathRoot Terminal option. The result must be an absolute POSIX-style path. |
|
Port |
Under server-based SQL engines you can define a port for server communications. The default for MySQL is 3306 and ProstgreSQL it is 5432. |
|
Database management system |
With server-based DBMS engines your database has an internal database name. In SQLite this is always main. |
|
Username |
With server-based DBMS engines, which implements internal security, you must logon with a Username and Password, already set up by your Database Administrator. This determins your privileges within the database. |
|
Password |
With server-based DBMS engines, which implements internal security, you must logon with a Username and Password, already set up by your Database Administrator. This determins your privileges within the database. |
|
Button |
Action |
|---|---|
|
Browse |
Click to browse to the SQLite database. To create a new one type in the path and new file name. |
Advanced
Advanced logon and client connection parameters. This applies only to Server Engines and not SQLite. It ia a list with two columns. It automatically extends when you tab out of the last line’s Value field.
This tab pane can contain many additional connection parameters that overwrite standard defaults. Many of these are performance and tuning options which are best not dabbled with. Because the program expects to set and select dates that have an empty value the session $defaultdate is always set to ” and $emptydateisnull is set kFalse in SQLite and MySQL, and 1st Jam 1800 for PostgreSQL.
|
Field |
Description |
|---|---|
|
Property or $connectoption |
Advanced parameters (lower-case begining with $) or HostServer $conectoption constants (mixed-case begining with k). |
|
Value |
| See also: – |
Compiled in Program Version 5.10. Help data last modified 8 Jan 2015 05:31:00.00. Class wSqlInitSettings last modified 10 Oct 2017 11:48:51.
Reference Contents > Preferences > Database Connection Settings
