1. Home
  2. General Program Functions
  3. General Program Functions: Database Connection Settings *

General Program Functions: Database Connection Settings *

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 
Advanced 

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.

Back to top

Advanced

Advanced logon and client connection parameters.

Back to top

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.

Updated on May 27, 2020

Was this article helpful?

Related Articles

Leave a Comment