Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Accessing the public folder data from LDAP or SQL?

Status
Not open for further replies.

oppcos

Programmer
Dec 1, 2004
209
US
Hi,
I'm tring to access my public folders data from MSSQL Server so that I can do joins against the databases other data. I started with using the Exchange OLE DB Provider but got the error:
Code:
Could not locate registry entry for OLE DB provider 'exoledb.DataSource.1'
After a little research I believe this may be due to the fact Exchange does not run on the same server as the database. (If anyone knows of a work-around for that, that would be ideal!)

My second attempt is to connect to Exchange with Active Directory Services as that was suggested on the web for someone else. I have some success. I can browse the folders now, but I can't get into any data within the public folders. Is there a special LDAP or otherwise query secret for getting, say, the list of contacts I have under the public folder Test? Here is what I have tried:
Code:
exec sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5', 'ADsDSOObject', 'adsdatasource'
...
select * from 
	openquery(ADSI, 'select * 
	from ''LDAP://exchange-server''')

I hope it is OK to post this question in the Exchange forum. It covers so many technologies it was hard to decide where to ask, really. Thanks for any help or suggestions!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top