Querying Active Directory from SQL Server 2005

[jllg2000]

I got this query:

CREATE VIEW viewADContacts
AS
SELECT [Name], SN [Last Name], ST State
FROM OPENQUERY( ADSI2,
'SELECT Name, SN, ST
FROM ''LDAP://presidencia.local/CN=Users,
DC=domainname,DC=local''')
GO

And i got this error:

Msg 7321, Level 16, State 2, Procedure viewADContacts, Line 3
An error occurred while preparing the query "SELECT Name, SN, ST
FROM 'LDAP://presidencia.local/CN=Users,
DC=domainname,DC=local'" for execution against OLE DB provider "ADSDSOObject" for linked server "ADSI2".


I have Microsoft SQL Server 2005 and i would like create a VIEW with DATA from Active Directory.

Please help me !!!!

Thanks !

[RedSon]

I got this query:

CREATE VIEW viewADContacts
AS
SELECT [Name], SN [Last Name], ST State
FROM OPENQUERY( ADSI2,
'SELECT Name, SN, ST
FROM ''LDAP://presidencia.local/CN=Users,
DC=domainname,DC=local''')
GO

And i got this error:

Msg 7321, Level 16, State 2, Procedure viewADContacts, Line 3
An error occurred while preparing the query "SELECT Name, SN, ST
FROM 'LDAP://presidencia.local/CN=Users,
DC=domainname,DC=local'" for execution against OLE DB provider "ADSDSOObject" for linked server "ADSI2".


I have Microsoft SQL Server 2005 and i would like create a VIEW with DATA from Active Directory.

Please help me !!!!

Thanks !

Please do not post your questions in the Job forum. Can't you read the title of the forum?

[ugk]

What a crappy thing to say to someone, can you read this?

[armandtan]

Truely!

What an idiot RedSon.

[ck9663]

Let's help him anyway..........


Read about VIEWS here

-- CK