Getting description field from Active Directory in MSSQL2005 (LDAP)

Question

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 their some datatype i can use to handle the object it is trying to return.

Answer 1

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