nschwend
asked on
ADSI into a stored procedure
Hello everybody,
I've done a stored procedure which collect the objectSID, the name and the sAMAccount of all the users into the domain. Now the system engineer added 10 new (not standard) categories into the Active Directories Objects. I have to take a value stored in a new object called "aimWfGalaxyID".
Everytime I try to call this new object from the recordset an error occurs. The data and the object exist because I checked more than 10 times...
everyone knows how to solve my problem?
thanxs in advance
nick
I've done a stored procedure which collect the objectSID, the name and the sAMAccount of all the users into the domain. Now the system engineer added 10 new (not standard) categories into the Active Directories Objects. I have to take a value stored in a new object called "aimWfGalaxyID".
Everytime I try to call this new object from the recordset an error occurs. The data and the object exist because I checked more than 10 times...
everyone knows how to solve my problem?
thanxs in advance
nick
ASKER
Hi,
this is a small part of my source:
...
exec @error = sp_oaSetProperty @conn, 'Provider', 'ADSDSOObject;'
exec @error = sp_oaMethod @conn, 'Open'
exec @error = sp_oaSetProperty @recordset, 'Source', 'SELECT objectSID, aimWfGalaxyID, name FROM ''LDAP://DC=webdew,DC=net' ' WHERE ObjectClass = ''user'' and ObjectCategory = ''Person'' ORDER BY name'
exec @error = sp_oaSetProperty @recordset, 'ActiveConnection', @conn
exec @error = sp_oaMethod @recordset, 'Open'
...
when I print the last @error it gives to me the following code: -2147467259
the error is a run-time error.
I hope it can helps you...
Thanx again
Nick
this is a small part of my source:
...
exec @error = sp_oaSetProperty @conn, 'Provider', 'ADSDSOObject;'
exec @error = sp_oaMethod @conn, 'Open'
exec @error = sp_oaSetProperty @recordset, 'Source', 'SELECT objectSID, aimWfGalaxyID, name FROM ''LDAP://DC=webdew,DC=net'
exec @error = sp_oaSetProperty @recordset, 'ActiveConnection', @conn
exec @error = sp_oaMethod @recordset, 'Open'
...
when I print the last @error it gives to me the following code: -2147467259
the error is a run-time error.
I hope it can helps you...
Thanx again
Nick
You don't have to use sp_oa to connect to ADSI. You can create a linked server and reference it directly in T-SQL. See if this link helps. https://www.experts-exchange.com/questions/20899910/Creating-a-linked-server-to-ADSI.html
ASKER
I tried using the procedure that you linked but it gives me always the same error that received 'klax'. I also tried changing the LDAP query but doesn't work either...
I don't know what to do... Now I'm looking if I've setted all the permissions on the new objects...
I don't know what to do... Now I'm looking if I've setted all the permissions on the new objects...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can you post more about your issue?