All,
I am in dire need of a solution. I used to have my .net application on my
exchange server but have since moved it to a separate server (which is
running SQL 2000). The application basically grabs leave form requests and
stores them on the sql server. It uses Exchange 2003 to route e-mails and to
store the time off on a public calendar. Everything still works fine except
for the public calendar. As I found via google, you cannot use exoledb as
your provider unless the code is on the exchange server. Does anyone have an
alternative (maybe with WebDAV) to the small piece of code below that does
not use exoledb?
---
' Reference to Microsoft ActiveX Data Objects 2.5 Library
' Reference to Microsoft CDO for Exchange 2000 Library
' Reference to Active DS Type Library
Function CreateAppointment(ByVal StartDate As Date, _
ByVal EndDate As Date, ByVal stime As String, _
ByVal etime As String, ByVal Subject As
String, _
ByVal Location As String, _
ByVal TextBody As String) As CDO.Appointment
Try
Dim iAppt As New CDO.Appointment
Dim Conn As New ADODB.Connection
Conn.Provider = "ExOLEDB.DataSource"
With iAppt
.StartTime = "#" & StartDate & "#"
.EndTime = "#" & EndDate & "#"
.Subject = Subject
.Location = Location
.TextBody = TextBody
.BusyStatus = "OOF"
.MeetingStatus = "Tentative"
'Save the appointment in a public folder calendar
Conn.Open("http://myserver/public/leaveform/")
..DataSource.SaveToContainer("http://myserver/public/leaveform/", Conn)
End With
CreateAppointment = iAppt
Conn.Close()
Catch err As Exception
Console.WriteLine(err.ToString())
CreateAppointment = Nothing
End Try
End Function
---
I would greatly appreciate any help and would be glad to share any knowledge
I have gained from .net apps with SQL and exchange.
Thank you,
Ken Wigle
wi*****@uc.edu
