2. ASPRunnerPro General questions
  3. ASP Runner integration with Outlook Calendars
This topic is locked

ASP Runner integration with Outlook Calendars

 		9/2/2010 9:45:35 AM
ASPRunnerPro General questions
Stu author

Does anyone have any tips on how to link ASPRunner to Exchange so that I could look at Diaries and post Diary entries? WHat I'd like to do it show availability of engineers in a web page, book an engineer and put it into their diary.
Sergey Kornilov admin 9/2/2010

Don't have any personal experience with this.
Theoretically speaking ASPRunnerPro is able to connect to Outlook and Exchange. You will need to use 'Connection string' option on Database connection type screen.
Here are a few examples of connection strings.
# Connecting to an Outlook 2000 personal mail box using the JET OLE DB Provider:

Provider=Microsoft.Jet.OLEDB.4.0;Outlook 9.0;MAPILEVEL=;DATABASE=C:\Temp\;


Replace c:\temp with any temporary folder. It will create a schema file in that folder when you open it which shows all the fields available. Blank MAPILEVEL indicates top level of folders).

**

Connecting to an Exchange mail box through JET:**


Provider=Microsoft.Jet.OLEDB.4.0;Exchange 4.0;MAPILEVEL=Mailbox - Pat Smith|;DATABASE=C:\Temp\;


You must replace c:\temp with any temporary folder.
Replace Pat Smith with the name of the mail box and you must keep vertical pipe character | to indicate top level of folders. Place sub folder after vertical pipe if accessing specific folder.
Stu author 9/6/2010

Sergey,
Thanks for the help.
Regards,
Stu



Don't have any personal experience with this.
Theoretically speaking ASPRunnerPro is able to connect to Outlook and Exchange. You will need to use 'Connection string' option on Database connection type screen.
Here are a few examples of connection strings.
# Connecting to an Outlook 2000 personal mail box using the JET OLE DB Provider:

Provider=Microsoft.Jet.OLEDB.4.0;Outlook 9.0;MAPILEVEL=;DATABASE=C:\Temp\;


Replace c:\temp with any temporary folder. It will create a schema file in that folder when you open it which shows all the fields available. Blank MAPILEVEL indicates top level of folders).

**

Connecting to an Exchange mail box through JET:**


Provider=Microsoft.Jet.OLEDB.4.0;Exchange 4.0;MAPILEVEL=Mailbox - Pat Smith|;DATABASE=C:\Temp\;


You must replace c:\temp with any temporary folder.
Replace Pat Smith with the name of the mail box and you must keep vertical pipe character | to indicate top level of folders. Place sub folder after vertical pipe if accessing specific folder.