Example code to access a public calendar using ADO - Microsoft Exchange
This is a discussion on Example code to access a public calendar using ADO - Microsoft Exchange ; Hi all,
My original brief was to get info from a calendar in the public folder
in exchange, displayed in ColdFusion on a remote server. I couldn't
find a way to make this happen, so the revised idea is to ...
-
Example code to access a public calendar using ADO
Hi all,
My original brief was to get info from a calendar in the public folder
in exchange, displayed in ColdFusion on a remote server. I couldn't
find a way to make this happen, so the revised idea is to run a .NET
(C# or VB) application on the Exchange 2000 server, to access the info
using ADO and CDOEX with the ExOLEDB provider, and write the results
to a remote SQL database. (Then pull the results out of that into
ColdFusion).
The problem is that apart from C# and SQL Server, I have never dealt
with any of these languages before.
I have seen many people say that ADO is the way to go to access the
folder and message information, and if I want to modify it (which I
don't), to use CDOEX. That's fair enough, but I can't actually find
any example code showing me how to do this. I've been working on this
project for two weeks solid and have read a lot but not made much
progress, so instead of posting links, I'd really appreciate it is
somebody could post some code to show me how to:
- Login to Exchange if you need to?
- Get to the appropriate calendar in the public store.
- Read the appointment messages in the calendar.
We're running Exchange 2000 on Windows 2000 Server.
Thank you very much!
Sarah
-
Re: Example code to access a public calendar using ADO
The Exchange SDK which you can download from
http://msdn.microsft.com/exchange is the best place to start it has a lot of
samples for what you are trying to do eg
http://msdn.microsoft.com/library/de...and_ado_vb.asp .
I would have thought that you should be able to use ColdFusion okay if you
use a bit of WebDAV (and Jscript) there are samples of doing a WebDAV search
of the calendar (which will work remotely) here
http://msdn.microsoft.com/library/de...ers_webdav.asp
Cheers
Glen
"Sarah" <sarah_c_clough@hotmail.com> wrote in message
news:ade0fb17.0411240437.5664f691@posting.google.com...
> Hi all,
>
> My original brief was to get info from a calendar in the public folder
> in exchange, displayed in ColdFusion on a remote server. I couldn't
> find a way to make this happen, so the revised idea is to run a .NET
> (C# or VB) application on the Exchange 2000 server, to access the info
> using ADO and CDOEX with the ExOLEDB provider, and write the results
> to a remote SQL database. (Then pull the results out of that into
> ColdFusion).
>
> The problem is that apart from C# and SQL Server, I have never dealt
> with any of these languages before.
>
> I have seen many people say that ADO is the way to go to access the
> folder and message information, and if I want to modify it (which I
> don't), to use CDOEX. That's fair enough, but I can't actually find
> any example code showing me how to do this. I've been working on this
> project for two weeks solid and have read a lot but not made much
> progress, so instead of posting links, I'd really appreciate it is
> somebody could post some code to show me how to:
>
> - Login to Exchange if you need to?
> - Get to the appropriate calendar in the public store.
> - Read the appointment messages in the calendar.
>
> We're running Exchange 2000 on Windows 2000 Server.
>
> Thank you very much!
> Sarah
-
Re: Example code to access a public calendar using ADO
Thanks for the links, they were very useful.
"Glen Scales [MVP]" <gscales@outlookexchange.com> wrote in message
news:%23$m$6Yp0EHA.1652@TK2MSFTNGP11.phx.gbl...
> The Exchange SDK which you can download from
> http://msdn.microsft.com/exchange is the best place to start it has a lot
> of
> samples for what you are trying to do eg
> http://msdn.microsoft.com/library/de...and_ado_vb.asp .
>
> I would have thought that you should be able to use ColdFusion okay if you
> use a bit of WebDAV (and Jscript) there are samples of doing a WebDAV
> search
> of the calendar (which will work remotely) here
> http://msdn.microsoft.com/library/de...ers_webdav.asp
>
> Cheers
> Glen
>
> "Sarah" <sarah_c_clough@hotmail.com> wrote in message
> news:ade0fb17.0411240437.5664f691@posting.google.com...
>> Hi all,
>>
>> My original brief was to get info from a calendar in the public folder
>> in exchange, displayed in ColdFusion on a remote server. I couldn't
>> find a way to make this happen, so the revised idea is to run a .NET
>> (C# or VB) application on the Exchange 2000 server, to access the info
>> using ADO and CDOEX with the ExOLEDB provider, and write the results
>> to a remote SQL database. (Then pull the results out of that into
>> ColdFusion).
>>
>> The problem is that apart from C# and SQL Server, I have never dealt
>> with any of these languages before.
>>
>> I have seen many people say that ADO is the way to go to access the
>> folder and message information, and if I want to modify it (which I
>> don't), to use CDOEX. That's fair enough, but I can't actually find
>> any example code showing me how to do this. I've been working on this
>> project for two weeks solid and have read a lot but not made much
>> progress, so instead of posting links, I'd really appreciate it is
>> somebody could post some code to show me how to:
>>
>> - Login to Exchange if you need to?
>> - Get to the appropriate calendar in the public store.
>> - Read the appointment messages in the calendar.
>>
>> We're running Exchange 2000 on Windows 2000 Server.
>>
>> Thank you very much!
>> Sarah
>
>
Similar Threads
-
By Application Development in forum ADO DAO RDO RDS
Replies: 0
Last Post: 02-10-2006, 07:56 PM
-
By Application Development in forum Microsoft Exchange
Replies: 0
Last Post: 11-24-2004, 07:23 AM
-
By Application Development in forum Microsoft Exchange
Replies: 1
Last Post: 09-22-2004, 12:37 PM
-
By Application Development in forum Microsoft Exchange
Replies: 0
Last Post: 09-21-2004, 03:49 AM
-
By Application Development in forum Microsoft Exchange
Replies: 1
Last Post: 04-07-2004, 08:33 AM