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

I Do Not Know The Correct Values For My Multi-Tier DSN. What Do I Do?

The following guidelines enable you to establish the values that you need to pass in a client/server Data Source Name. Name Provide any descriptive title for your Data Source Name. Limit the name to 32 characters and start with an alphanumeric character. Description You may provide an optional description for your Data Source Name. Server This field passes the hostname or IP address of the machine that contains your OpenLink server components installation. It also passes the TCP port on which the Request Broker listens. If you do not know the hostname or IP address of the machine, you may run hostname on the console. If you do not have access to the console, contact its System Administrator. The Broker's TCP port is recorded in the Session Rules Book. The Session Rules Book is the oplrqb.ini file that appears in the /bin sub-directory of the OpenLink server components installation. It may be opened with any text editor. For example:

[Request Broker]
BinaryDirectory  = c:\openlink\openlink software\uda\multi-tier\v5.1\bin
CommandLine      =
Protocols        = tcp
;MaxAgents   = 0
;MaxConnections   = 0
HostNameResolver = Yes
LingerTimeout    = 0

[Protocol TCP]
PingWatchdog = No
PingInterval = 600
;IPAddress      = 127.0.0.1
PortLow      = 5025
PortHigh   = 6000
Listen       = 5025
The Broker TCP port is the port value that is passed to Listen. (OpenLink 1.x and 3.x users use PortLow.) Once you have determine your hostname and port number, use the following syntax to pass the information:
hostname:port

Domain This field passes the name of a valid Domain Alias. A full list of Domain Aliases appears in the Session Rules Book. The Session Rules Book is the oplrqb.ini file that appears in the /bin sub-directory of the OpenLink server components installation. It may be opened with any text editor. Here is a sample [Domain Aliases] list:

[Domain Aliases]
DB2            = db2
Informix 7.3   = inf5
Informix 2000  = inf6
Ingres II      = ing6
Odbc           = odbc
Oracle 8.1.x   = ora8

Your Domain Alias value must match one of these values. Observe case and spacing! Additionally, your Domain Alias must map to one or more rules, database agent configuration sections, and environment settings. Contact OpenLink Product Support for additional information. Database This field passes the name of the database or an Oracle SID. If you do not know the name of your database, contact your Database Administrator.

Login ID This field passes the username that you need to pass to connect to your database. This username may be a standard database username. However, if you use the specialized OPSYSLOGIN parameter, you need to pass operating system authentication parameters. If you do not know your database username, you must consult your Database Administrator. Password This field passes the password that you need to pass to connect to your database. This password may be a standard database password. However, if you use the specialized OPSYSLOGIN parameter, you need to pass operating system authentication parameters. If you do not know your database username, you must consult your Database Administrator.