[signon]

Use the [signon] section of the dbridge.cfg file to enter information for signing on to the relational database and the DATABridge Server Accessory on the host.

The configuration file must include the data source (or database, if using Oracle), signon parameters to access the relational database, and a user and a password (unless you use the SQL Server client with Integrated Windows authentication).

Parameter

Description

database

Deprecated in DATABridge 6.0 and later for Microsoft SQL Server client.

Default: None
Command-line option: -D

(Oracle) This parameter is the name that identifies the Oracle instance or the Net8 service that is being accessed. If the service name contains non-alphanumeric characters, you must enclose it in double quotation marks, as follows:

database = "orcl.cin.attachmate.com"

ODBCdatasource

Default: None
Command-line option: -O

(Microsoft SQL Server) This parameter is the name that identifies the ODBC data source used to access the SQL database. This ODBC data source is configured within the Control Panel during the Client installation procedure.

(DB2/Informix) This is the CLI data source, which typically is the name of the database being accessed.

hostpasswd

Default: None
Range: 17 alphanumeric characters
Command-line option: -X

Use the host password parameter to specify the password associated with the Server Accessory on the host. This parameter must match exactly the KEY parameter defined in the Host Server control file. For example:

DBServer

KEY = "Secret"

dbridge.cfg

hostpasswd = Secret

Note: The password is always encoded in the (binary) client configuration file. Exported (text) client configuration files can include encoded or readable passwords. For more information, see "Export the Client Configuration to a File" in the DATABridge Client Console Help. Passwords are not encoded in communications between DATABridge Client and the Server Accessory.

password

Default: None
Command-line option: -P

Use the password parameter to specify the password associated with the user ID for the relational database. The password must be valid for the user ID or the connection to the relational database server fails.

If your password contains non alphanumeric characters other than the underscore, you must enclose the password in double quotes, as follows:

password = "a$bb%"

Note: The password is always encoded in the (binary) client configuration file. Exported (text) client configuration files can include encoded or readable passwords. For more information, see "Export the Client Configuration to a File" in the DATABridge Client Console Help. Passwords are not encoded in communications between DATABridge Client and the Server Accessory.

server

Deprecated in DATABridge 6.0 and later for Microsoft SQL Server client.

user

Default: None
Command-line option: -U

Use the user parameter to specify the user ID for the relational database. The user ID must have the appropriate resource privileges for the designated relational database, as explained in Setting Up a User ID (Windows) in the DATABridge Installation Guide.

use_nt_authen

Default: False
Range: True or False
Command-line option: -W

The use_nt_authen parameter applies to Microsoft SQL Server clients only.

Use Windows ODBC Data Source Administrator to set the required ODBC data source authentication method.

Use this parameter as follows:

  • Set the use_nt_authen parameter to True when Microsoft SQL Server is set to use the Windows operating system authentication for access to the SQL Server data. The SQL Server verifies the authenticity of the login ID with Integrated Windows authentication.
  • Set the use_nt_authen parameter to False when Microsoft SQL Server is set to use its own authentication instead of that provided by the operating system. The SQL Server verifies the authenticity of the login ID with SQL Server authentication using a Login ID and password entered by the user.

[signon] parameters with equivalent environment variables

[signon] Parameter

Variable

Option

dbutility Command

database

Note: The database parameter is deprecated in DATABridge 6.0 and later for Microsoft SQL Server client.

DBDATABASE

-D

All

datasource

 

-O

All (does not apply to Oracle)

hostpasswd

DBHOSTPW

-X

define, redefine, process, clone, and switchaudit

password

DBPASSWD

-P

All

user

DBUSERID

-U

All