var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I've created a linked server on SQL server 2000 using the followin code:
EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5', 'ADSDSOObject', 'ADsDataSource'
I then try to do a select statement using the following code:
SELECT * FROM OPENQUERY(ADSI, 'SELECT Name FROM "LDAP://DomianName.com/OU=IT_OU_LON,OU=London,DC=DomainName,DC=com"')
But I keep getting the following error:
Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB provider 'ADsDSOObject'.
Can anyone help?
Are there configuration settings I need to do?
Do I need to install anything on the Server which has SQL?
Your help is much appreciated