The only field I cannot grab is the description field from our AD. The error is:
我无法抓取的唯一字段是AD的描述字段。错误是:
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.
无法从OLE DB提供程序“ADsDSOObject”获取链接服务器“ADSI”的行数据。由于符号不匹配或溢出以外的原因,无法转换数据值。
Is there some datatype I can use to handle the object it is trying to return?
我可以使用一些数据类型来处理它试图返回的对象吗?
2 个解决方案
#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).
我想你的问题是AD可以在一个字段中存储多个值(与关系数据库中的第一个规范化规则完全相反)。
Not sure what your query looks like - but could you possibly try to add a "[0]" indexer to the description attribute, by any chance??
不确定你的查询是什么样的 - 但你有可能尝试在描述属性中添加“[0]”索引器吗?
Marc
#2
I have the same problem getting the Description field from AD while attempting to use ADsDSOObject and ADO.
我在尝试使用ADsDSOObject和ADO时从AD获取Description字段时遇到同样的问题。
you have to inter-ate through the values with a For Each or Do until ... EOF type of statement.
你必须通过For Each或Do直到... EOF类型的语句来交换值。
这是一个很好的例子
#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).
我想你的问题是AD可以在一个字段中存储多个值(与关系数据库中的第一个规范化规则完全相反)。
Not sure what your query looks like - but could you possibly try to add a "[0]" indexer to the description attribute, by any chance??
不确定你的查询是什么样的 - 但你有可能尝试在描述属性中添加“[0]”索引器吗?
Marc
#2
I have the same problem getting the Description field from AD while attempting to use ADsDSOObject and ADO.
我在尝试使用ADsDSOObject和ADO时从AD获取Description字段时遇到同样的问题。
you have to inter-ate through the values with a For Each or Do until ... EOF type of statement.
你必须通过For Each或Do直到... EOF类型的语句来交换值。
这是一个很好的例子