Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Connecting to Outlook 2003 from SQL Server 2005 Expand / Collapse
Author
Message
Posted Wednesday, July 23, 2008 8:17 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 26, 2013 9:13 PM
Points: 40, Visits: 108
Hi all,

Is there a way I can access and query emails stored in Outlook 2003 from SQL 2005/2008? If anyone can direct a weblink for more information or post detailed information is apprecaited. Thanks.
Post #539813
Posted Wednesday, July 23, 2008 9:12 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, January 25, 2012 8:14 AM
Points: 567, Visits: 512
I have never done this. This would lead to a huge security hole and a million other problems. Consider having an application layer do this for you. It will be easier, faster, and more secure. Would you mind laying out why you feel the DB needs to connect directly to exchange? I am sure we can come up with something without exchange and sql having direct conn.
Post #539827
Posted Wednesday, July 23, 2008 9:27 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 26, 2013 9:13 PM
Points: 40, Visits: 108
Thanks for the update. If this is going to create security worries, is it possible import inbox saved as a file. We are planning to do some analysis on email received/sent on a monthly bases.
Post #539829
Posted Wednesday, July 23, 2008 9:52 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, January 25, 2012 8:14 AM
Points: 567, Visits: 512
That sounds kind of cheesey. Have you research the exchanged API or development kits. You could proably get faster help on an exchange message board. Sorry cant point you to any of those boards, I view Email as a virus in the data tier. Most DBA still use snail mail for interoffice communication anyway

Good luck!!!
Post #539834
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse