Post reply

Read Users Outlook/Exchange Calendar

  • November 20, 2011 at 1:10 pm

    #146145

    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

    #1410547

    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

    #1410971

    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

    #1411071

    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

    #1411086

    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