asked on

Query Exchange Calendar & Address Book

I have ASP code which will open show a calendar in Exchange. I also have code which will return the GAL. However, I can only get this working by running the ASP page from the Exchange server. Is there any way I can run the ASP page(s) from the webserver (which is on a physically different server)?

Another quick question..is there another way to interface with the Exchange Calendar apart from AMHTML.Renderer as this isn't installed on the webserver?

Cheers

webwoman

If you've already gotten it to work on the Exchange server, you're ahead of the game. You'll have to have some connection between the webserver and the Exchange server. Not quite sure what would be the best way... you could set up a virtual directory that gets its contents from the appropriate directory on the Exchange server.

That might be easiest. If you've already got the ASP files on the Exchange server and they work, just make that folder the virtual directory in the webserver, and you should be able to call it just like it was physically there.

ASKER CERTIFIED SOLUTION

aleceiffel

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

aleceiffel

Your last question: Another way to render the calendar is to use CDO to query the appointment entries, and then render them as you please using plain asp/HTML. This would give you maximum flexibiliy, but lots of extra work! You would still need cdo installed, this can be done by simply registering cdo.dll on your server.
A quick and dirty way to render the calendar is of course to have frames in your web-app pointing to outlook web access which probably is installed on your exchange server!

mparter

ASKER

So I can install OWA on the webserver without having to install Exchange?

Can you point me towards some sample code?

Thanks for your time/help.

aleceiffel

>So I can install OWA on the webserver without having to install Exchange?
Yes you can, there is a separate selection for this on the setup program for Exchange 5.5.

About sample code, I am not sure what you are looking for, It seems to me that you already have the code you need running on the exchange server.

mparter

ASKER

I meant some sample code for querying the calendar using CDO and outputting as I want, not using the AMHTML.Renderer.

Thanks.

aleceiffel

You can find sample code for querying appointment items here: http://msdn.microsoft.com/msdnmag/issues/0600/cdo/default.aspx

mparter

ASKER

That link you provided was great. Just one problem, I couldn't get it to work when trying to apply the filter, like so:

Set oFilter = oMessages.Filter
oFilter.Fields.Add ActMsgPR_END_DATE, CDate("01/12/2002 12:00 AM")
oFilter.Fields.Add ActMsgPR_START_DATE, CDate("01/11/2002 12:00 AM")

I get the following error:

[Collaboration Data Objects - [E_INVALIDARG(80070057)]]

Any ideas?

aleceiffel

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q192404&

mparter

ASKER

That's it now, thanks very much for your help. Gonna give you the points for all your help. Cheers.

Nest step, trying to use this to access a public folder, on we go...

mparter

ASKER

Just a quickie:

In the MS example for filtering, the date is hard coded into the example like so:

StartTime = #11/01/2002#
EndTime = #12/01/2002#

is there any way to do this dynamically? I tried this:

StartTime = "#" & Month(Now) & "/01/" & Year(Now) & "#"
EndTime = "#" & Month(Now)+1 & "/01/" & Year(Now) & "#"

but it doesn't like a string!

MaxOvrdrv2

StartTime="#" & Month(Date) & "/01" & Year(Date) & "#"
EndTime= "#" & Month(DateAdd("m",Date,1)) & "01" & Year(Date) & "#"

MaxOvrdrv2

Query Exchange Calendar &amp; Address Book

Query Exchange Calendar & Address Book