Sql – Getting description field from Active Directory in SQL Server 2005 (LDAP)

active-directoryldapsql-server-2005

The only field I cannot grab is the description field from our AD. The error is:

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.

Is there some datatype I can use to handle the object it is trying to return?

Best Solution

I guess your problem is the fact that AD can store multiple values in a single field (quite contrary to the very first normalization rule in relational databases).

Not sure what your query looks like - but could you possibly try to add a "[0]" indexer to the description attribute, by any chance??

Marc