Database Connection Settings
Reference Contents > General Program Functions > Database Connection Settings
|
Field |
Description |
|---|---|
|
iBasicRow.Suffix |
A suffix can be added to the licensed company name (e.g. Ltd., Inc, of TEST DATA). |
|
Button |
Action |
|---|---|
|
Revert |
Click to revert to the previously saved condition. |
|
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. |
|
Save |
Click to save any changes you have made. |
|
Delete |
Click to delete the settings for the currently selected Company. |
Select the license name for the database connection.
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.
The window has 2 tab panes.
Basic
Basic logon parameters.
|
Field |
Description |
|---|---|
|
iBasicRow.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. |
|
iBasicRow.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. |
|
iBasicRow.Database |
With server-based DBMS engines your database has an internal database name. In SQLite this is always “main”. |
|
iBasicRow.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. |
|
iBasicRow.HostMac |
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. |
|
iBasicRow.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). |
|
iDirectPath |
When this company is logged onto, this combined path will be used to locate supporting files: Extras, Custom, ProgUser.db, ProgSyst.db, etc.. |
|
iBasicRow.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.. |
|
Button |
Action |
|---|---|
|
Click to browse to the SQLite database. To create a new one type in the path and new file name. |
Select the Database Engine you propose to use.
Advanced
Advanced logon and client connection parameters.
Compiled in Program Version 5.00. Help data last modified 29 Dec 2014 02:39. Class wSqlInitSettings last modified 29 Dec 2014 10:25:36.
Reference Contents > General Program Functions > Database Connection Settings
