Administrator Guide > Administrator Guide > Gateway Alias Configuration > Alias Parameters > Host Dbname Parameter Table
Was this helpful?
Host Dbname Parameter Table
The host dbname is the native DBMS name used to access the target DBMS. The syntax and meaning are specific for each DBMS. See the documentation for your target DBMS for additional information on database names. The following table lists the types of host dbname for each gateway:
Gateway
Form
Hostdb
Microsoft SQL
hostdb
Specifies the ODBC System DSN or File DSN name that specifies access to Microsoft SQL Server. The ODBC entry contains the information needed to access a local or remote Microsoft SQL Server installation.
Be sure to specify an explicit login database name. If the Use Trusted Connection permission is selected, all users accessing this database are given the Database Owner (DBO) role.
Oracle
hostdb
Specifies the Oracle database name (SID) used to access a local database.
 
@dbserver
Specifies the remote Oracle tnsname used to access a remote database using Oracle Net Services. The value dbserver is an entry in the tnsnames.ora file. The dbserver entry must contain SID information.
 
hostdb@dbserver
Specifies the Oracle database name used to access a remote database using Oracle SQL*Net. The value dbserver is an entry in the tnsnames.ora file. The hostdb value may be ignored under these circumstances since there may be an explicit Oracle SID specified in the tsnames.ora entry.
ODBC HOST
hostdb
Specifies the ODBC host Data Source Name (DSN) used to access the ODBC host. The ODBC DSN contains the information needed to access a local or remote ODBC installation.
Last modified date: 08/22/2022