topic LDAP Connection with Port Number in QlikView

LDAP Connection with Port Number

Tue, 23 Oct 2012 15:17:46 GMT

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.

Re: LDAP Connection with Port Number

Anonymous — Wed, 24 Oct 2012 01:37:19 GMT

Hi Nigel,

The first thing I would test is:

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

Re: LDAP Connection with Port Number

Wed, 24 Oct 2012 07:33:18 GMT

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.

Re: LDAP Connection with Port Number

Wed, 24 Oct 2012 12:57:56 GMT

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.

Re: LDAP Connection with Port Number

qlikviewforum — Tue, 23 Jul 2013 12:07:23 GMT

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