Question & Answer
Question
How do you make an ODBC connection to an Oracle server based IBM® Rational® RequisitePro® (ReqPro)?
Answer
In order for an Oracle database server to receive connections from clients, clients must be configured with service names. These service names are easily remembered aliases or nicknames, which reference database addresses. These aliases match an address, which is configured on the database server's listener.ora file. The client uses the database server address in order to establish a connection to the network listener. During this connection, the client passes the system ID (SID) of the server for which it would like to connect.
Client configuration is accomplished by creating a list of service names and addresses of network destinations. This list is referenced in the tnsnames.ora file. This file may be modified directly through a text editor, or through a "Configuration Assistant" such as Net8 Assistant (if an 8i) version of Oracle is installed.
This file will include the following data:
REQPRO.RATIONAL.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sus-bmsmith02)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = reqpro)
)
)
On the first line there is a listing of an Alias or Service:
For example: Reqpro or Reqpro.rational.com if a global name names variable is set
- Refer to TN#1121114 for more information regarding a global names variable.
This reference is simply the alias or nickname of how the Oracle database server is identified on the Oracle client. In RequisitePro it is suggested that all users will connect with the same alias name.
PROTOCOL = TCP
Additionally, there is a reference to the Oracle database server. The host may be identified using either host name or server name.
HOST = sus-bmsmith02
The port used on the Oracle database server is also identified.
Note: The default port is 1521.
PORT = 1521
Finally, the Service Name on the Oracle database server is referenced. This is the name of the SID on the server.
SERVICE_NAME = reqpro
In RequisitePro, a user connects to an Oracle schema through an ODBC connection. An ODBC connection is established using the Microsoft ODBC driver for Oracle. The RequisitePro application uses the data in the user's local TNSNAMES.ORA file in order to establish an ODBC connection to the server. The entries referenced in the TNSNAMES.ORA file such as the HOST, TCP protocol, PORT, and SERVICE_NAME are used to establish this connection. If the user can connect successfully, than the data in the RequisitePro project .rqs and .rql files are used to connect to a specific schema in the Oracle database instance.
Refer to TN#1128973 for more information regarding the use of Oracle Names Severs.
Related Information
Historical Number
127429908
Was this topic helpful?
Document Information
More support for:
Rational RequisitePro
Software version:
2003.06.13, 2003.06.14, 2003.06.15, 2003.06.16, 7.0, 7.0.0.1, 7.0.0.2, 7.0.0.3, 7.0.0.5, 7.0.0.6, 7.0.0.7, 7.0.1, 7.0.1.1, 7.0.1.2, 7.0.1.3, 7.0.1.4, 7.0.1.5, 7.0.1.6, 7.0.1.7, 7.1, 7.1.0.1, 7.1.0.2, 7.1.1
Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows
Document number:
326805
Modified date:
16 June 2018
UID
swg21128969