This information pertains to Windows This information pertains to UNIX and Linux.

Some ODBC applications display a logon dialog box when you are connecting to a data source. In these cases, the data source name has already been specified.

Figure 1. Logon to Oracle Wire Protocol dialog box

The Logon to Oracle Wire Protocol dialog box

In this dialog box, provide the following information:

Note: For TNSNames connections, skip to Step 4.
  1. In the Host field, type either the name or the IP address of the server to which you want to connect. Note:
    Note:
    • The IP address can be specified in either IPv4 or IPv6 format, or a combination of the two.
    • If you enter a value for this field, the Server Name field is not available.
    • If you enter a value for the LDAP Distinguished Name field, this field specifies name or address of the LDAP directory server.
    • This field is not available if you enter a value for the Server Name field.
  2. In the Port Number field, type the number of your Oracle listener. Check with your database administrator for the correct number.
    Note:
    • If you enter a value for this field, the Server Name field is not available.
    • If you enter a value for the LDAP Distinguished Name field, this field specifies the port number listener of the LDAP directory server.
    • This field is not available if you enter a value for the Server Name field.
  3. Provide a value for one of the following options:
    • In the SID field, type the Oracle System Identifier that refers to the instance of Oracle running on the server.
    • In the Service Name field, type the Oracle service name that specifies the database used for the connection. See "Service Name" in "Connection option descriptions" for details.
    • In the LDAP Distinguished Name field, type the fully qualified path of names in the LDAP directory information tree for the entry containing your connection information.

    Skip to Step 6

  4. In the Server Name field, type a net service name that exists in the TNSNAMES.ORA file. The corresponding entry in the TNSNAMES.ORA file is used to obtain Host, Port Number, and SID information.
    Note:
    • If you enter a value for this field, the Host, Port Number, SID, and Service Name fields are not available.
    • If you enter a value for either the Host, Port Number, SID, or Service Name fields, this field is not available.
  5. If you are using an Oracle Wallet Password Store (AuthenticationMethod=16), in the Oracle Wallet field, type your the password used to access the Oracle Wallet in which your database credential information is stored. Skip to Step 7
  6. If required, provide values for one of the following fields:
    • Password: Type your Oracle user name.
    • Entra Access Token: Enter your Entra ID Access Token.
    Note: Entra Access Token is only exposed when using Entra ID access token authentication (AuthenticationMethod=38)
  7. Optionally, in the Impersonate User field, type the proxy user ID used for impersonation. This value determines your identity and permissions when executing queries. Note that the administrator must grant permission to the authenticated user to impersonate the specified proxy user ID.
  8. Click OK to log on to the Oracle database installed on the server you specified and to update the values in the Registry.
Note: You can also use OS Authentication to connect to an Oracle database. See "OS authentication" for details.