LDAP Connection with Port Number

[#1]

Hi Folks

I need some help please on accessing data from LDAP.

I have a server which is oiddev.servername.com, the domain is xyz.com and LDAP is only available through port number 4032, which is the bit that I'm struggling with, at the moment I have a query which is:

SELECT name, distinguishedName FROM 'LDAP://oiddev.servername.com DC=xyc DC=com'

Does anybody know how I can change the above query to read from Port number 4032?

Thanks for any help.

Nigel.

[Anonymous]

Hi Nigel,

The first thing I would test is:

SELECT name, distinguishedName FROM 'LDAP://oiddev.servername.com:4032 DC=xyc DC=com'

[#3]

Hi Johannes

Thanks for replying on this one, I have tried what you suggest, but get

the following:

ErrorSource: Active Directory, ErrorMsg: An invalid directory pathname

was passed

UserTable:

SELECT name, distinguishedName

FROM 'LDAP://oiddev.swissbank.com:4032 DC=ubsw DC=com'

Any thoughts?

Nigel.

[#4]

Hi Johannes

I have got past the invalid path name, so now I'm issuing a command as

follows:

SELECT name, distinguishedName

FROM 'LDAP://oiddev.swissbank.com:4032/dc=ubsw,dc=com'

This gets me past the error on Path Name but then gives me an QVX

Unexpected end of file error.

We have a group on our AD system called NEO_CUBE_ENDUSERS and what I'd

really like to get at it a list of unique members from this group, do

you have any idea how I do that?

Nigel.

[qlikviewforum]

Hi,

The QVW which tries to load the data from LDAP loads only the partial data frequently. We are unable to find the root cause of the issue as the QVW doesn't fails but it loads only the partial data.Can someone please help us to identify the root cause of the issue. It has been happening from quite a long time but we didn't succeed in finding the root cause of the issue. Hope someone can help us for the same.

Regards,

qvforum