November 20, 2011 at 1:10 pm
Is it possible to read a users calendar appointments in exchange using sql server. I really dislike the way the default calendar prints so thought I would create a report that would print out appointments for the given dates
November 21, 2011 at 2:25 am
You can set up a linked server to your Exchange using this:
http://msdn.microsoft.com/en-us/library/ms191461.aspx
Hope this helps
Gianluca
-- Gianluca Sartori
November 21, 2011 at 11:52 am
Thanks. I will give it a try. My next question will be - how would I determine the table names for the calendar and users.
November 21, 2011 at 3:00 pm
Are you sure this applies to later versions of Exchange, this explicitly talks about Exchange 2000, does it work with higher versions?
CEWII
November 21, 2011 at 3:47 pm
Not sure. Our exchange server is on a different server to a SQL Server 2008 so have run into some issues. I will try again later - but would appreciate help from anyone who has got something like this working. Currently I get the error
The OLE DB provider "exoledb.Datasource.1" has not been registered: Microsoft SQL Server Error 7403
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply