Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Need Help with this Error Message

Author  Topic 

osirisa
Constraint Violating Yak Guru

289 Posts

Posted - 2010-10-20 : 11:23:53
Hi Group:
I need some help with this Error Message received when I try to import LDAP attributes in a query. Enclosed is the query for your review. The attribute other Mobile is the once causing the Error in SQL2005. Anyone with a solution and/or seen this problem before.
----------------------------------------------------------------------
'SELECT otherMobile, employeenumber, sAMAccountName, ADsPath, cn, name, mail, displayName, initials, givenName, sn,telephoneNumber,mobile
----------------------------------------------------------------------

Error Message:

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.
   

- Advertisement -