Post reply

query OpenLDAP

  • June 24, 2009 at 8:15 am

    #135390

    When trying to run this query to OpenLDAP 2.3.27 (RedHat flavor):

    SELECT convert(varchar(5), [givenName]) as FirstName

    FROM OPENQUERY( ADSI,

    'SELECT givenName

    FROM ''LDAP://10.15.1.236:390/ O=mycompany,c=US''

    WHERE uid = ''jsmith'' and objectClass = 'Person'' ' )

    Msg 7346, Level 16, State 2, Line 5

    Cannot get the data of the row from the OLE DB provider "ADSDSOObject" for linked server "ADSI". Could not convert the data value due to reasons other than sign mismatch or overflow.

    ldap log shows:

    conn=29 op=0 BIND dn="uid=mysuer,o=mycompany,c=US" mech=SIMPLE ssf=0

    conn=29 op=0 RESULT tag=97 err=0 text=

    conn=29 op=1 SRCH base="o=mycompany,c=US" scope=0 deref=0 filter="(objectClass=*)"

    conn=29 op=1 SRCH attr=objectClass

    conn=29 op=1 SEARCH RESULT tag=101 err=0 nentries=1 text=

    conn=29 op=2 SRCH base="o=mycompany,c=US" scope=2 deref=0 filter="(&(uid=jsmith)(objectClass=Person))"

    conn=29 op=2 SRCH attr=givenname

    conn=29 op=2 SEARCH RESULT tag=101 err=0 nentries=0 text=

    I get same error message on SQL Server 2005 32 bit and 64 bit.

  • June 24, 2009 at 12:28 pm

    #1014844

    I found one MS KB related to this, but we have the latest version of that ActiveDS.dll which is 5.2.3790.3959 (srv03_sp2_rtm.070216-1710). It's from 2007, they were talking about 2004.

    http://support.microsoft.com/kb/887474

    I saw some minor mention that this might be an array that is getting returned. I even tried varchar(max). Does anyone have hints on this?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply