I am trying to query active directory to get the groups and their members. I am trying to conduct access reviews. When I try to get the 'member' attribute, I get the following error
Could not get the data of the row from the OLE DB provider 'ADSDSOObject'. Could not convert the data value due to reasons other than sign mismatch or overflow.
OLE DB error trace [OLE/DB Provider 'ADSDSOObject' IRowset::GetData returned 0x80040e21: Data status returned from the provider: [COLUMN_NAME=member STATUS=DBSTATUS_E_CANTCONVERTVALUE]]
From what I understand, the member attribute is returned as an array. Is there a way to get that into SQL Server 2000? I know I can get this via .net, but I would like to keep it all in SQL Server.