Thread: Active directory Update
07-22-04, 08:06 #1Registered User
- Join Date
- Jul 2004
Unanswered: Active directory Update
I want to write a trigger that add a new computer account in my active directory when I do an Insert in my MSSQL table.
I know how to use SELECTstatements using LDAP but I want to do a INSERT statement. Is that even possible?
Can you write vb code directly in SP i mssql 2000?
What I think I have to do is to have a vbscript that does the adding then call the script using exetended SP cmd execute passing the name to the script.
If someone has a another solutions please let me know!
07-23-04, 02:13 #2Registered User
- Join Date
- Jul 2003
- San Antonio, TX
I've written simple ActiveX out-of-process OLE servers using VB. This is not hard to do. But I think you're going from the wrong direction. I'd rather add a computer account using LDAP from my VB code and then fire a stored procedure to update whatever you want to update. The other way around is possible too, but it doesn't make it easier, not does it make it right either."The data in a record depends on the Key to the record, the Whole Key, and
nothing but the Key, so help me Codd."