LDAP support

heidenbluth · Post by **heidenbluth** » Fri 24 Aug 2007 11:47

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

Plash · Post by **Plash** » Mon 27 Aug 2007 08:12

Yes, LDAP can be used with ODAC.

heidenbluth · Post by **heidenbluth** » Fri 31 Aug 2007 07:57

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?

Plash · Post by **Plash** » Fri 31 Aug 2007 08:55

ODAC does not support LDAP with the Net option set to True.

heidenbluth · Post by **heidenbluth** » Fri 31 Aug 2007 09:21

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?

Plash · Post by **Plash** » Fri 31 Aug 2007 11:19

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.

Devart Forums

LDAP support

LDAP support

Example, Prerequisites