Ask a question?
  • Contact Us
  • Support Case System
  • Support Forum

What Values Do Multi-Tier Users Need To Pass In Their Data-Sources?

Multi-Tier users must pass the following values in their Multi-Tier DSNs:

Name A descriptive name that identifies the Data Source.
Server Passes the hostname or IP address of the server on which the Multi-Tier Request Broker listens. Also passes the TCP port on which the Broker listens. The format is host:port.
Domain This value corresponds to a Domain Alias that appears in the [Domain Aliases] section of the Session Rules Book. Default Domain Aliases are named after the databases to which the database agent connect. Custom Domain Aliases may take any form.
Database This is the name of the database or Oracle SID.
Login ID This is a valid database username.
Password This is a valid database password.

Are the Multi-Tier Request Broker and DBMS installed on separate machines? If so, users must add one of the following values to the DSN:

DB2 Server/Adapter Passes a remote DB2 database alias.
Informix Server Passes the name of the Informix server.
Ingres Net (vnode) Passes vnode::database name.
MySQL Connect Options Passes -H host -P port -T.
Oracle SQL*Net Alias Passes an Oracle SQL*Net alias.
PostgreSQL Connect Options Passes -H host -P port -T.
Progress Connect Options Passes Progress -S socket -H host -N tcp parameters.
SQLServer Connect Options Passes -S followed by a SQLServer instance name.
Sybase Connect Options Passes the Sybase instance name.