Post to Calendar with a DB Call?



I am having our Exchange Admin create a public calendar.

The goal is to allow people to request time for a resource.

One key to achieving this goal is to ensure that a exact amount of
time is alloted to the time request based on historical data. The
historical data will be stored in a SQL Server DB.

For example: if a requestor want to request a resource for "task X"
then I wish to invoke a DB call to find the average time for task X
then "automagically" set the start and end time in the Event interface
in Outlook. The start and end time should also be read only. This also
implies that the item "task X" is a predefined in a drop down list in
the Event interface.

I have been writting software with various products since 1997. I can
handle the DB part without much problem. Building the form for outlook
is a foreign topic to me.

Is this possible with a reasonable amount of effort?

If so can someone please supply a few pointers? Any suggested book
titles that will lead me in the right direction?

.



Relevant Pages

  • Re: Resource reservation problem
    ... I am positive the request is not directly made on the resource calendar. ... Are you sure the client is using the "Make a Meeting" to send the request? ... if you re-read the original posting my concern is with Outlook 2007 ...
    (microsoft.public.outlook.calendaring)
  • Re: Resource reservation problem
    ... I never modified the resource's Exchange properties. ... I am positive the request is not directly made on the resource calendar. ... Scenario: From my Outlook 2007 client: create new meeting ...
    (microsoft.public.outlook.calendaring)
  • Re: writing to an outlook folder
    ... I have made an assembly that access to Outlook 2003 ... Windows applications. ... ASP.NET is not authorized to access the requested resource. ... granting access rights to the resource to the ASP.NET request identity. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Resource reservation problem
    ... I have no problems sending reservation requests from OWA. ... When I book the resource from the Outlook client, ... because when I send a request from OWA. ...
    (microsoft.public.outlook.calendaring)
  • Re: MsiInstaller detection of product...feature...failed
    ... Word and Outlook at the Office apps. ... The resource 'HKEY_CLASSES_ROOT\.pip\' does not exist. ... 'WORDFiles' failed during request for component ...
    (microsoft.public.windowsxp.help_and_support)