Active Directory ADO.NET Connection Manager

gravatar

billinkc

Create an ADO.NET connection manager that uses the .Net Providers for OleDb\OLE DB Provider for Microsoft Directory Services.

published 11.22.13

last updated 11.22.13


Share

                            


<Biml xmlns="http://schemas.varigence.com/biml.xsd">
	<Connections>
		<!-- Change the Data Source to reflect your domain controller -->
		<AdoNetConnection
			Name="AD"
			Provider="System.Data.OleDb.OleDbConnection, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
			ConnectionString="Data Source=HOME.BILLFELLOWS.NET;Provider=ADsDSOObject;Integrated Security=SSPI;"
        />
	</Connections>
</Biml>

This creates an ADO.NET connection manager that uses the .Net Providers for OleDb\OLE DB Provider for Microsoft Directory Services. The Data Source should point at your domain controller

To find a DC, from a command prompt, type

set | find /i "userdnsdomain"
You are not authorized to comment. A verification email has been sent to your email address. Please verify your account.

Comments

gravatar

mohit6

8:07pm 12.20.18

Hi,

When i try your code, i get the error:

The connection string is not valid. Keyword not supported: 'provider'.

It seems that the provider keyword is not supported inside the connection string.

Please let me know how to make it work.

Thanks!!

Regards, Mohit