Database connection strings

A connection string contains all information to establish a connection to a database. The format of the connection string differ per database.

For the supported database type Oracle Server the format of the connection string is:

ORACLE:[service_name:<service_name>][sid:<sid>];<user>;<passwd>

For Oracle Server a <service_name> or a <sid> can be defined.


String	Description
<service_name>	Name of the service The name can be found in the table: 'Databases' (ttaad410.para; resource: ORACLE_SERVICE_NAME). On runtime present in <BSE>\lib\tabledef6.2
<sid>	System ID The ID can be found in the table 'Databases' (ttaad410.para; resource: ORACLE_SID). On runtime present in the <BSE>\lib\tabledef6.2 For example: `::oracle8(ORACLE_SID=insttst):N`
<user>	Name of the user group Based on the current LN user, the database user (ttdba010), database group (ttdba015), and password (ttdba020) can be retrieved. On runtime present in <BSE>\lib\ora\ora_groups (first segment).
<passwd>	The encrypted password of the user group, see <user>. On runtime present in <BSE>\lib\ora\ora_groups (second segment).

For the supported database type Microsoft SQL Server MSQL the format of the connection string is:

<server>;<database>;<user>;<passwd>


String	Description
<server>	Name of the server The name can be found in the table: 'Databases' (ttaad410.para; resource: MSQL_SERVERHOST). On runtime present in <BSE>\lib\tabledef6.2 For example: `::msql7(MSQL_SERVERHOST=NLBAWAPPSDEV1)`
<database>	Name of the database Same as <user>
<user>	Name of the user group Name of the user group. Based on the current LN user, the database user (ttdba010), database group (ttdba015), and password (ttdba020) can be retrieved. On runtime present in `<BSE>\lib\msql\msql_groups` (first segment).
<passwd>	The encrypted password of the user group, see <user>. On runtime present in <BSE>\lib\msql\msql_groups (second segment).