| Author |
Message |
cb
Guest
|
Posted:
Tue Oct 11, 2005 12:56 am Post subject:
snapshot updating Exchange Calendar from SQL |
|
|
Any leads on where to start with this project? I've looked around online a
little bit, but haven't seen any starting points. I think I've heard
exchange is more or less an SQL database, so I should be able to connect via
ODBC... yes?
Essentially we have calendar information in an SQL database, but users want
to be able to see this in their Exchange accounts (public calendar). We've
tried individual calendar additions, but the problem is it's only insert; no
update or delete information. We're hoping snapshots (or even better) merge
would allow us to display the SQL dates in an Exchange public calendar.
Any links, info, guidance will be appreciated.
CB
|
|
| Back to top |
|
 |
Tom Rizzo [MSFT]
Guest
|
Posted:
Tue Oct 11, 2005 12:58 am Post subject:
Re: snapshot updating Exchange Calendar from SQL |
|
|
Exchange has an OLEDB provider but its only on the server-side. You can't
really setup Exchange as a subscriber for SQL replication. You could write
a program to sync between Exchange and SQL.
Tom
--
Looking for a good book on programming Exchange, Outlook, ADSI and
SharePoint? Check out http://www.microsoft.com/MSPress/books/5517.asp
"cb" <clb39@cornell.edu> wrote in message
news:OlRkwSdzFHA.2424@TK2MSFTNGP12.phx.gbl...
| Quote: | Any leads on where to start with this project? I've looked around online a
little bit, but haven't seen any starting points. I think I've heard
exchange is more or less an SQL database, so I should be able to connect
via ODBC... yes?
Essentially we have calendar information in an SQL database, but users
want to be able to see this in their Exchange accounts (public calendar).
We've tried individual calendar additions, but the problem is it's only
insert; no update or delete information. We're hoping snapshots (or even
better) merge would allow us to display the SQL dates in an Exchange
public calendar.
Any links, info, guidance will be appreciated.
CB
|
|
|
| Back to top |
|
 |
cb
Guest
|
Posted:
Wed Oct 12, 2005 4:58 pm Post subject:
Re: snapshot updating Exchange Calendar from SQL |
|
|
Tom -
I do have access to the SQL server and the Exchange administrator is
interested in this project so I have exchange server access. I'm not sure if
the book referenced is part of your recommendation or you signature. Any web
resources that you recommend for starting points on this project?
Thanks again,
Chris Beardsley
"Tom Rizzo [MSFT]" <thomriz@microsoft.com> wrote in message
news:uVZZb8ezFHA.1252@TK2MSFTNGP09.phx.gbl...
[quote]Exchange has an OLEDB provider but its only on the server-side. You can't
really setup Exchange as a subscriber for SQL replication. You could
write a program to sync between Exchange and SQL.
Tom
--
Looking for a good book on programming Exchange, Outlook, ADSI and
SharePoint? Check out http://www.microsoft.com/MSPress/books/5517.asp
"cb" <clb39@cornell.edu> wrote in message
news:OlRkwSdzFHA.2424@TK2MSFTNGP12.phx.gbl...
Any leads on where to start with this project? I've looked around online
a little bit, but haven't seen any starting points. I think I've heard
exchange is more or less an SQL database, so I should be able to connect
via ODBC... yes?
Essentially we have calendar information in an SQL database, but users
want to be able to see this in their Exchange accounts (public calendar).
We've tried individual calendar additions, but the problem is it's only
insert; no update or delete information. We're hoping snapshots (or even
better) merge would allow us to display the SQL dates in an Exchange
public calendar.
Any links, info, guidance will be appreciated.
CB
[/quote]
|
|
| Back to top |
|
 |
Glen Scales [MVP]
Guest
|
Posted:
Thu Oct 13, 2005 6:34 am Post subject:
Re: snapshot updating Exchange Calendar from SQL |
|
|
Tom's book is a great place to start with Exchange programming the other
resource you might want to check out is the Exchange SDK which you can
download from http://msdn.microsoft.com/exchange .
Also you might want to have a look at
http://www.logicom-inc.com/xp_sql2exchange/ I've never used this before but
it does look Interesting I suspect they are using MAPI under the covers so
you could roll your own if you have the time and resources to do it.
Cheers
Glen
"cb" <clb39@cornell.edu> wrote in message
news:%233N8D%23zzFHA.3896@TK2MSFTNGP10.phx.gbl...
[quote]Tom -
I do have access to the SQL server and the Exchange administrator is
interested in this project so I have exchange server access. I'm not sure
if the book referenced is part of your recommendation or you signature.
Any web resources that you recommend for starting points on this project?
Thanks again,
Chris Beardsley
"Tom Rizzo [MSFT]" <thomriz@microsoft.com> wrote in message
news:uVZZb8ezFHA.1252@TK2MSFTNGP09.phx.gbl...
Exchange has an OLEDB provider but its only on the server-side. You
can't really setup Exchange as a subscriber for SQL replication. You
could write a program to sync between Exchange and SQL.
Tom
--
Looking for a good book on programming Exchange, Outlook, ADSI and
SharePoint? Check out http://www.microsoft.com/MSPress/books/5517.asp
"cb" <clb39@cornell.edu> wrote in message
news:OlRkwSdzFHA.2424@TK2MSFTNGP12.phx.gbl...
Any leads on where to start with this project? I've looked around online
a little bit, but haven't seen any starting points. I think I've heard
exchange is more or less an SQL database, so I should be able to connect
via ODBC... yes?
Essentially we have calendar information in an SQL database, but users
want to be able to see this in their Exchange accounts (public
calendar). We've tried individual calendar additions, but the problem is
it's only insert; no update or delete information. We're hoping
snapshots (or even better) merge would allow us to display the SQL dates
in an Exchange public calendar.
Any links, info, guidance will be appreciated.
CB
[/quote] |
|
| Back to top |
|
 |
|
|
|
|