Hi Claudio,
sorry for the late reply.

I think that OPENQUERY is trying to determine the datatypes being returned from LDAP and getting it wrong for the departmentNumber field. Instead of doing a SELECT TOP 800 *, select the fields individually and cast the departmentNumber field to a TEXT datatype, or perhaps a SQL_Variant to accomodate potentially different datatypes in the same column.
There are some gotchas with LDAP queries, see this

‘Select *’ in a query against AD does not return all fields as you might expect that it would. Instead, it returns the ADsPath of the object. There is no way to return all fields. – See more at: http://www.skylinetechnologies.com/Insights/Skyline-Blog/May-2013/Querying-Active-Directory-through-SQL-Server-Using#sthash.0N5MhUHC.dpuf

sAMAccountName
givenName
sn
departmentNumber

My query is:

SELECT top 800 * FROM OPENQUERY(ADSI, ‘SELECT departmentNumber,sn, givenName, displayName, sAMAccountName
FROM ”LDAP://ABCDCOP01.XXX.int/DC=XXX,DC=int”
WHERE objectClass = ”User” and objectCategory = ”person”
‘)

when I run, I get a message:

Msg 7341, Level 16, State 2, Line 1
Cannot get the current row value of column “[ADsDSOObject].departmentNumber” from OLE DB provider “ADsDSOObject” for linked server “ADSI”. Could not convert the data value due to reasons other than sign mismatch or overflow.

Note: I know that this message is because the attribute departmentNumber. How can I solve this? because if I remove these attribute I get the result.

Here what I did in ssrs using odbc connected to postgresql: select {col} from {table} where ltrim(to_char({col}, ‘999999’))=any (string_to_array(?,’,’)) and in the dataset parameter function: =join(Parameters!ReportParameter.Value,”,”)

When we run thi directly on server, it works well. But same when excuted via client throws following error message. Any thoughts?

Msg 7321, Level 16, State 2, Line 2
An error occurred while preparing the query “SELECT givenName,sn,employeeid,sAMAccountName,mail,type,whenChanged
FROM ‘LDAP://*****/DC=*******,DC=***,DC=**’
WHERE objectClass = ‘User’ AND objectCategory = ‘Person’ AND (
SN = ‘A*’
)
” for execution against OLE DB provider “ADsDSOObject” for linked server “ADSI”.

Normally I would mark this as spam, but it is just so beautiful it almost makes me want to cry

Hi Silver A, are your columns numeric? If so then try the version without the apostrophes.

Can you verify the values that are being generated in the ParamList? If you can then try and verify the query works with the ParamList values. i.e. try and run the query directly on Oracle. e.g. if you can verify your ParamList is returning the values 1, 2, 3, 4 then try running this on Oracle using the SQL Developer or whatever tool you use.
Select ORDER_NUM from ORD_ORDER where ORDER_NUM in (1,2,3,4);

I am missing something?

Yes I can confirm this works in SQL Server 2012, and in 2014. I’m not suprised by that either. You can even just type an LDAP query into an internet browser and it will work. It’s just a protocol with an address and some arguments.

LDAP querying can be generally painful and finicky. Can you get into AD via MMC or some other tool?
You might be able to use that to then see what the OU structure is in your shop’s AD.
Then try some simpler variation on this to see if you can get anything back at all:
SELECT * FROM OpenQuery(ADSI, 'SELECT cn, distinguishedName FROM ''LDAP://OU=Client Computers,OU=Resources,DC=Domain,DC=com,DC=au'' ')

You might even be able to browse the linked server’s structure using SSMS. In the object explorer, under server objects, expand the tree for the Linked Server.

i tried like this but always returning blank page