Page 1 of 1
LDAP support
Posted: Fri 24 Aug 2007 11:47
by heidenbluth
I was asked from my customer if any of our ODAC-based applications supports database connect via LDAP as an alternative to TNS.
Does ODAC support LDAP connect strings?
Regards,
Holger
Posted: Mon 27 Aug 2007 08:12
by Plash
Yes, LDAP can be used with ODAC.
Example, Prerequisites
Posted: Fri 31 Aug 2007 07:57
by heidenbluth
I remember if I want to connect with ODAC without Sql*Net I have to set TOraSession.Options.Net := true. Is there nothing like that I must do to tell the session to use LDAP instead of TNS? How does the connect string look like in this case? I would assume a quoted list of node items like
"node1=value1, node2=value2, node3=value3"
Does Oracle Sql*Net handle it all, and I don't have to pass any information to ODAC that forces the LDAP way?
Currently, I set TOraSession.Options.Net automatically to true if there is a colon in the connection string. I am afraid it must be set manually now.
Do you now if a LDAP connection string can contain colons?
Posted: Fri 31 Aug 2007 08:55
by Plash
ODAC does not support LDAP with the Net option set to True.
Posted: Fri 31 Aug 2007 09:21
by heidenbluth
Thank you, but that doesn't answer my question. I want to know:
- Is there an Option of TOraSession set must be set for LDAP
- Are there special prerequisites such as Oracle software
additionally to SQL*Net?
- How does the connect string look like for LDAP?
Posted: Fri 31 Aug 2007 11:19
by Plash
The TOraSession component has no option that should be set for using LDAP.
Your 2nd and 3rd questions are not related to ODAC. You can find answers to them in the Oracle documentation.