471,356 Members | 1,655 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,356 software developers and data experts.

Alternative to EXOLEDB?

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
Jul 22 '05 #1
0 1016

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

46 posts views Thread by Robin Becker | last post: by
99 posts views Thread by Paul McGuire | last post: by
1 post views Thread by Morten | last post: by
reply views Thread by Ken Wigle | last post: by
3 posts views Thread by Will McGugan | last post: by
11 posts views Thread by Francine.Neary | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.