SQL and OWA

[technisup]

I'd like to take 5 fields from a SQL db, in order to use them in OWA,
specifically in Outlook, so i can add, for instance, in the Outlook's
calendar an event and i retreive from the db the list of teachers that i
have, select some one and left it registered in Outlook.. this is for a web
application.. is this possible, if so, how?

Thanks in advance for the help that you can help me.

 

[philhege]

Sounds like you need a .NET application with a hook to the Outlook interop assembly. Create the data access object(s) and spin through the dataset results to set the Outlook event object properties.

Be careful about using Office applications programmatically on a server. This scenario is not supported by Microsoft.

Since this is a Web application, you may want to consider constructing vCal files and emailing them to the recipients. When they open the vCal file, it will automatically add the event to their calendar.

Check with the .NET and/or Office forums here for more ideas and details, and Google "SQL Server Outlook interaction". This group is specifically concerned with SQL programming.

Phil H.
-----------
A virtual machine ate my accounting data. I transferred it to a physical box, then I beat it to smithereens with a sledgehammer. I feel better.