How to read AD using LDAP?

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
eeyore
Posts: 6
Joined: Tue Jul 06, 2010 6:58 am

How to read AD using LDAP?

Post by eeyore »

Hello,

I'm trying to display some of our Active Directory (AD) user information on an OOo form. It seems the form can connect to AD via the OOo 'LDAP Address Book' connector. But when I click on the 'LDAP Directory' table, I get an error message: 'The data content could not be loaded. An error occurred while executing the query.'

In the 'Database properties - Advanced Properties' panel, I have entered the following values:

Database type: LDAP Address Book

Host name: my-server-name.mycompany.org (Note: these are not the actual values - I'm just substituting fake ones for privacy's sake.

User name: [blank]

Test Connection button: clicking on it results in message: 'Connection Test. The connection was established successfully.')

Base DN: have tried 'DC=org' and 'DC=mycompany,DC=org'

Port number: 389

Maximum number of records: 10

Any help would be hugely appreciated. Thank you.
Eeyore
(OOo v 3.2.1, Win XP sp3)
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: How to read AD using LDAP?

Post by r4zoli »

I not using LDAP, looked around in issueTracker, and found several bugs with LDAP, most interesting two:
http://qa.openoffice.org/issues/show_bug.cgi?id=85356
http://qa.openoffice.org/issues/show_bug.cgi?id=111440

The LDAP connector needs a developer, Base To-Do/SDBC driver for LDAP directories, in this link, you can find a short description about LDAP driver limits in current OOo.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
eeyore
Posts: 6
Joined: Tue Jul 06, 2010 6:58 am

Re: How to read AD using LDAP?

Post by eeyore »

Thank you, r4zoli. The LDAP bugs you referenced seem similar to the ones I'm experiencing. I think I'll need to put LDAP connectivity aside until the bugs are fixed.
Eeyore
(OOo v 3.2.1, Win XP sp3)
Post Reply