Exchange-SQL server connectivity

I am fairly new to both the technologies.
Scenario:
I have an Exchange server on one machine, with Outlook. I
am looking for a way to get the information from Exchange
servers (mainly public folders) to SQL-server that is
located on a different machine.
My problem is as follows:
a. I need to get data from Exchange to SQL-server, real
time.
I am going through a round-about way of getting this
information. I have created Linked tables in an Access
Database that exports the data to the SQL-server (on the
same machine). It is not real time.
I can not seem to see the Linked tables from Access
when I use DTS.
There has to be a better way to do this.
Please advise.
Deven
for real time, open the outlook to the mailbox, using Outlook VBA NewMessage
write code to the sql server. Just leave the outlook open.
"deven" <anonymous@.discussions.microsoft.com> wrote in message
news:7cfa01c43149$c84894b0$a001280a@.phx.gbl...
> I am fairly new to both the technologies.
> Scenario:
> I have an Exchange server on one machine, with Outlook. I
> am looking for a way to get the information from Exchange
> servers (mainly public folders) to SQL-server that is
> located on a different machine.
> My problem is as follows:
> a. I need to get data from Exchange to SQL-server, real
> time.
> I am going through a round-about way of getting this
> information. I have created Linked tables in an Access
> Database that exports the data to the SQL-server (on the
> same machine). It is not real time.
> I can not seem to see the Linked tables from Access
> when I use DTS.
> There has to be a better way to do this.
> Please advise.
> Deven
>

Exchange-SQL server connectivity

I am fairly new to both the technologies.
Scenario:
I have an Exchange server on one machine, with Outlook. I
am looking for a way to get the information from Exchange
servers (mainly public folders) to SQL-server that is
located on a different machine.
My problem is as follows:
a. I need to get data from Exchange to SQL-server, real
time.
I am going through a round-about way of getting this
information. I have created Linked tables in an Access
Database that exports the data to the SQL-server (on the
same machine). It is not real time.
I can not seem to see the Linked tables from Access
when I use DTS.
There has to be a better way to do this.
Please advise.
Devenfor real time, open the outlook to the mailbox, using Outlook VBA NewMessage
write code to the sql server. Just leave the outlook open.
"deven" <anonymous@.discussions.microsoft.com> wrote in message
news:7cfa01c43149$c84894b0$a001280a@.phx.gbl...
> I am fairly new to both the technologies.
> Scenario:
> I have an Exchange server on one machine, with Outlook. I
> am looking for a way to get the information from Exchange
> servers (mainly public folders) to SQL-server that is
> located on a different machine.
> My problem is as follows:
> a. I need to get data from Exchange to SQL-server, real
> time.
> I am going through a round-about way of getting this
> information. I have created Linked tables in an Access
> Database that exports the data to the SQL-server (on the
> same machine). It is not real time.
> I can not seem to see the Linked tables from Access
> when I use DTS.
> There has to be a better way to do this.
> Please advise.
> Deven
>

Exchange/SQL/VB/Outlook (and possibly a little DDE for good measur

Hi Peoples,
- This is also logged in Exchange server Development Thread -
First let me start by saying I'm not sure if this is in the correct thread -
so a million apologies if it is a little of topic (and for the duplication).
Now...
I have a Windows Server 2003 environment with the following config:
- 2003 Server Enterprise (SP1)
- SQL Server 2000 (SP3)
- Exchange 2003 Enterprise (SP1)
- Outlook 2003 (Office 2003 SP1)
- 3rd Party Help Desk Software with SQL backend (and DDE engine if relevant)
The situation is this - If an email (with a specially formatted Subject
probably) is sent into my environment I would like (either via DDE, SMTP
Event Sink or VBScript) to have the data, subject and sender address of the
email (not taking into consideration any error handling at this stage)
dropped into SQL databases(s). Basically auto-generating a Helpdesk Job with
the emailed data.
I've tried tinkering with DDE - but on the whole have had limited to no
success with it, even at the most simple level. Correct me if I'm wrong, but
it (DDE) is painful, yeah? :)
I'm not clear whether this can be achieved through SMTP Event Sinks (though
I assume it can), or if this is really the most suitable solution.
I'm quietly confident that VBScript running on an XP box with Outlook 2003
with some simple "Rules" in place this could be achieved, but this is ugly
and a bit of a hack solution.
I have the site replicated in a Dev environment so I am in a position where
testing and so forth is feasible for a while.
If someone could shed a little light on the situation, and possibly offer
some direction/ideas that would be fantastic.
Thanking you in advance..
Matt.Hi
You may want to check out SQL Mail and the documentation in books online
regarding
xp_findnextmsg and xp_readmail
John
"Matty B" <MattyB@.discussions.microsoft.com> wrote in message
news:A1C3547E-0C2C-4765-ABD4-81610A9AB047@.microsoft.com...
> Hi Peoples,
> - This is also logged in Exchange server Development Thread -
> First let me start by saying I'm not sure if this is in the correct
> thread -
> so a million apologies if it is a little of topic (and for the
> duplication).
> Now...
> I have a Windows Server 2003 environment with the following config:
> - 2003 Server Enterprise (SP1)
> - SQL Server 2000 (SP3)
> - Exchange 2003 Enterprise (SP1)
> - Outlook 2003 (Office 2003 SP1)
> - 3rd Party Help Desk Software with SQL backend (and DDE engine if
> relevant)
> The situation is this - If an email (with a specially formatted Subject
> probably) is sent into my environment I would like (either via DDE, SMTP
> Event Sink or VBScript) to have the data, subject and sender address of
> the
> email (not taking into consideration any error handling at this stage)
> dropped into SQL databases(s). Basically auto-generating a Helpdesk Job
> with
> the emailed data.
> I've tried tinkering with DDE - but on the whole have had limited to no
> success with it, even at the most simple level. Correct me if I'm wrong,
> but
> it (DDE) is painful, yeah? :)
> I'm not clear whether this can be achieved through SMTP Event Sinks
> (though
> I assume it can), or if this is really the most suitable solution.
> I'm quietly confident that VBScript running on an XP box with Outlook 2003
> with some simple "Rules" in place this could be achieved, but this is ugly
> and a bit of a hack solution.
> I have the site replicated in a Dev environment so I am in a position
> where
> testing and so forth is feasible for a while.
> If someone could shed a little light on the situation, and possibly offer
> some direction/ideas that would be fantastic.
> Thanking you in advance..
> Matt.
>