Feedback

Feedback

Did this article resolve your question/issue?

   

Article

Oracle driver support to retrieve database connection strings from LDAP

Printable View

Information

 
TitleOracle driver support to retrieve database connection strings from LDAP
URL Namedoes-datadirect-odbc-oracle-wire-protocol-driver-support-retrieving-database-connection-strings-from-ldap
Article Number000111313
EnvironmentProduct: Connect/Connect64 for ODBC Oracle Wire Protocol driver, Porgress DataDirect for ODBC for Oracle Wire Protocol driver
Version: 7.1, 8.0
OS: All supported platforms
Database: Oracle
Application: All ODBC applications
Question/Problem Description
Does DataDirect ODBC Oracle Wire Protocol driver support retrieving database connection strings from LDAP?
Steps to Reproduce
Clarifying Information
Contents of LDAP entry:

C:\Users\lg)tnsping xxxxxxxx

TNS Ping Utility for 64-bit Windows: Version 11.2.0.2.0 - Production on 01-OCT-2018 13:44:08

Copyright (c) 1997, 2014, Oracle. All rights reserved.

Used parameter files:
xxxxxxxxxxxxxxx\sqlnet.ora

Used LDAP adapter to resolve the alias
Attempting to contact (DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=on)(DESCRIPTION=(CONNECT_TIMEOUT=10)(TRANSPORT_CONNECT_TIMEOUT=3000)(RETRY_COUN T=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxx)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=xxxxx) ))(DESCRIPTION=(CONNECT_TIMEOUT=10)(TRANSPORT_CONNECT_TIMEOUT=3000)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxx)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=xxxxx))))
OK (20 msec)

The database is active on xxxxxxx and data guard to xxxxxxx
 
Error Message
Defect NumberEnhancement
Enhancement Number
Cause
Resolution
The enhancement has been implemented. Upgrade to 08.02.2314 (B0588, U0417) or later.
A new connection option has been added to the driver as part of this enhancement.

New connection option LDAPDistinguishedName

This option is used to implement support for retrieving Oracle connection information from Oracle Internet Directory(OID) or Oracle Unified Directory(OUD). These are Oracle's implementations of LDAP server repositories. The DBA can add their Oracle connection info (via a net service name string) to a directory location in OID/OUD. To configure the driver to get it’s Oracle database connection info from LDAP, configure the connection URL or data source to specify the host name and port number of the LDAP server (rather than the Oracle database itself) and then set the LDAPDistinguishedName connection property to the location in the LDAP directory information tree where the database net service name string was registered. The driver will connect to the LDAP server, fetch the Oracle database connection details and then establish the connection to the database.


Note that the ODBC installation package is now re-distributing an in house built version of the Open LDAP library [libxxldap28*]. This is required by the driver in order to make the calls out to the LDAP server to gather the Oracle connection information.
Workaround
Notes
References to other documentation:
ODBC Oracle Wire Protocol driver does not support LDAP | DataDirect Ideas
https://datadirect.ideas.aha.io/ideas/DDIDEAS-I-100

Progress DataDirect for ODBC for Oracle Wire Protocol Driver User's Guide documentation, "Connection Option Descriptions" : "LDAP Distinguished Name"
https://documentation.progress.com/output/DataDirect/odbcoraclehelp/index.html#page/odbcoracle%2Fldap-distinguished-name.html%23


Progress Article(s):
Using Connect drivers with Oracle Internet Directory (OID)
Last Modified Date11/20/2020 6:53 AM
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.


Copyright © 2022 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.

Progress, Telerik, Ipswitch, Chef, Kemp, Flowmon and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.

Terms of Use Privacy Center Security Center Trademarks License Agreements Code of Conduct Careers Offices
Do Not Sell My Personal Information