snapshot updating Exchange Calendar from SQL
Exchange Server Forum Index Exchange Server
Discussion forums for Microsoft Exchange Server users.
Microsoft Outlook
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web ExchangeServerHelp.com
snapshot updating Exchange Calendar from SQL

 
Post new topic   Reply to topic    Exchange Server Forum Index -> Development
Author Message
cb
Guest





Posted: Tue Oct 11, 2005 12:56 am    Post subject: snapshot updating Exchange Calendar from SQL Reply with 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
Tom Rizzo [MSFT]
Guest





Posted: Tue Oct 11, 2005 12:58 am    Post subject: Re: snapshot updating Exchange Calendar from SQL Reply with 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...
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 Reply with 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...
[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 Reply with quote

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
 
Post new topic   Reply to topic    Exchange Server Forum Index -> Development All times are GMT
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




Windows Server Dedicated Servers
New Topics Powered by phpBB