Micro Focus Visual COBOL 2.3 Update 2 for Eclipse (UNIX) > Programming > Data Access > Database Connectors for Visual COBOL > Database Connectors Tasks > To Set Up a Service Name for an Oracle Database

To Set Up a Service Name for an Oracle Database

Restriction: This topic applies only when a Database Connectors license has been installed via the Micro Focus License Management System.

If you are using Oracle client software to connect to a database not on the current machine, you must set up a service name for your database. To set this up, you need the following details from your database administrator:

Service name
Protocol
Host name
Port

When you have these, you can use Oracle's Net Configuration Assistant, which is supplied with the Oracle client install. After entering the correct details, the wizard enables you to test the connection.

Tip: You can also test the connection using SQL*Plus: use user-name@service-name for the login.

If successful, you are ready to start configuring the Database Connectors client by editing the ACUFH configuration file. These connection details equate to the A_ORA_DATABASE (service name), ORA_LOGIN (user-name), and ORA_PASSWD (password) configuration variables.