Updating AD from SQL Server

16 Sep 2005 7:43 PM

Tim

I need to push some data from SQL Server to AD - phone number, office, etc. I
can get the data into SQL Server using a SELECT and the ADSI setup documented
on the MS KB, but updates on that same object fail with a "provider can't
handle that type of transaction" error.

Any ideas on how to best populate AD from SQL Server data? (carefully, of
course).

Tim

16 Sep 2005 8:21 PM

John Bell

Hi

Searching google turned up http://tinyurl.com/cykzj where Weiqing Tu [MS]
states

"ADSI OLEDB provider is a readonly provider, it does not supports
modification"

You may want to check to see if there is a newer version than the one you
are using!

John

Show quote

"Tim" <T**@discussions.microsoft.com> wrote in message
news:1416CE72-EB9B-4725-BDB0-BC032E432C04@microsoft.com...
>I need to push some data from SQL Server to AD - phone number, office, etc.
>I
> can get the data into SQL Server using a SELECT and the ADSI setup
> documented
> on the MS KB, but updates on that same object fail with a "provider can't
> handle that type of transaction" error.
>
> Any ideas on how to best populate AD from SQL Server data? (carefully, of
> course).
>
> Tim
>