Comments for Bravesoft Blog http://www.bravesoft.com/blog Just another WordPress weblog Mon, 1 Feb 2010 00:29:05 -0500 http://wordpress.org/?v=2.8.3 hourly 1 Comment on SQL Server – Extract Active Directory Data into Table by Kurin Lambert http://www.bravesoft.com/blog/?p=24&cpage=1#comment-758 Kurin Lambert Mon, 01 Feb 2010 00:29:05 +0000 http://www.bravesoft.com/blog/?p=24#comment-758 <a href="#comment-606" rel="nofollow">@Lawrence Bird </a> Hi Lawrence. Although I have not yet ran this code on a 2008 server, I would be surprised if that is what is causing your problem. Are you storing your query in a variable and then passing to OPENQUERY? OPENQUERY does not accept a variable for the query and will throw an error like the one above. @Lawrence Bird

Hi Lawrence. Although I have not yet ran this code on a 2008 server, I would be surprised if that is what is causing your problem. Are you storing your query in a variable and then passing to OPENQUERY? OPENQUERY does not accept a variable for the query and will throw an error like the one above.

]]> Comment on SQL Server – Extract Active Directory Data into Table by Lawrence Bird http://www.bravesoft.com/blog/?p=24&cpage=1#comment-664 Lawrence Bird Mon, 18 Jan 2010 19:50:16 +0000 http://www.bravesoft.com/blog/?p=24#comment-664 ARE YOU EVER GOING TO MODERATE!!!!! BTW: It would appear that the query is shortened? Every time I write more it chops off more and every time I remove attributes more of the code is run??? ARE YOU EVER GOING TO MODERATE!!!!!

BTW: It would appear that the query is shortened? Every time I write more it chops off more and every time I remove attributes more of the code is run???

]]> Comment on SQL Server – Extract Active Directory Data into Table by Lawrence Bird http://www.bravesoft.com/blog/?p=24&cpage=1#comment-606 Lawrence Bird Sun, 10 Jan 2010 12:48:20 +0000 http://www.bravesoft.com/blog/?p=24#comment-606 Hi there, this code is just what I've been looking for but when I attempt to execute the command, I get the error 'Unknown Syntax near 'OPENQUER' even though I have typed the code exactly as specified. Is it because I am using SQL SERVER 2008? Thanks Hi there, this code is just what I’ve been looking for but when I attempt to execute the command, I get the error ‘Unknown Syntax near ‘OPENQUER’ even though I have typed the code exactly as specified. Is it because I am using SQL SERVER 2008? Thanks

]]> Comment on SQL Server – Extract Active Directory Data into Table by Kurin Lambert http://www.bravesoft.com/blog/?p=24&cpage=1#comment-59 Kurin Lambert Mon, 09 Nov 2009 16:26:54 +0000 http://www.bravesoft.com/blog/?p=24#comment-59 <a href="#comment-22" rel="nofollow">@Bob Abeles </a> Bobby, LDAP connections to active directory from sql server are ready only. Therefore you cannot issue any 'update' sql statements. However you can use vb script to update active directory using ldap adsi. Do a web search for 'update active directory using ldap adsi vbs' and you should find several examples. @Bob Abeles
Bobby,

LDAP connections to active directory from sql server are ready only. Therefore you cannot issue any ‘update’ sql statements. However you can use vb script to update active directory using ldap adsi. Do a web search for ‘update active directory using ldap adsi vbs’ and you should find several examples.

]]> Comment on SQL Server – Extract Active Directory Data into Table by Bob Abeles http://www.bravesoft.com/blog/?p=24&cpage=1#comment-22 Bob Abeles Wed, 04 Nov 2009 13:31:55 +0000 http://www.bravesoft.com/blog/?p=24#comment-22 Kurin - I have a client that we need to do the reverse from your post. They have a MSSQL Database with over 500 user accounts. We need to have a method to export names/passwords from SQL to Active Directory to prevent the manual input as well. We are going to be implementing Microsoft TS to eliminate Browser issues on the clients we are having with a particular application. If you can provide info on the reverse strategy I would appreciate it. I am not A SQL DB and need your advise Bobby Kurin – I have a client that we need to do the reverse from your post. They have a MSSQL Database with over 500 user accounts. We need to have a method to export names/passwords from SQL to Active Directory to prevent the manual input as well. We are going to be implementing Microsoft TS to eliminate Browser issues on the clients we are having with a particular application. If you can provide info on the reverse strategy I would appreciate it.

I am not A SQL DB and need your advise

Bobby

]]>