Hi,

I am having problems with linking table from an exchange 5.5 server
into a sql server 7 server. We haven't migrated to Active Directory.

I run the command
sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',
'ADSDSOObject', 'adsdatasource'
go

and it runs ok

However I cannot run the next command properly and don't know why

I saw that there is something like this:

select cn, col2 from openquery(ADSI, 'select cn from
''LDAP://ExchangeServerName'' WHERE uid=''ExchangeUser''')
as adsiName, table1 where table1.col2 = adsiName.cn

HOWEVER I CANNOT GET IT TO WORK. I AM NOT SURE HOW TO MODIFY THE ABOVE
SQL STATEMENT FOR MY PARTICULAR SQL QUERY.
IM GETTING ERRORS LIKE:

An error occurred while preparing a query for execution against OLE DB
provider 'ADSDSOObject'.


Now however I can link the server to Microsoft Access with the linking
feature.

The message Access gives is : "Finished Linking table 'People' to file
'ORGANIZATION\BRAVO\People'.

Now when I open the linked table in access I get all the fields from
the exchange server list in the E-mail address column of the linked
table in access it says :
'/o=ORGANIZATION/ou=BRAVO/cn=People/cn=xxusernamexx' . Maybe this
might be of use?

However my question still states:

How to I execute that select statement for my particular exchange
server.
I have done research on the internet and I still cannot get it to
work.

ANY HELP OR DIRECTION WOULD BE GREAT.

Thanks

Dhruv

Archived from group: microsoft>public>adsi>general