Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Methods to populate Exchange contacts from SQL Server

Posted on 2008-11-04
Medium Priority
Last Modified: 2012-06-22
I am looking for a tool or package to simply cater for the following:

A SQL Server table contains contact information that is updated by a software package. All users have outlook and wish to have the information in the SQL Server table containing the contact information to be available in Outlook.

My idea is to synchronise an Exchange public folder with all the contact data, which can then be accessed by all users (or per an access plan).

I have found reference to extended stored procedures for SQL Server which take care of this (http://www.sqlservercentral.com/articles/Miscellaneous/2985/) however it seems the site that hosts these stored procedures (http://www.xpsql2exchange.com) is no longer available.

Does anyone else have access to these extended stored procedures or information relating to a method of a similar nature?

Thanks in advance.
Question by:pldervey
  • 2
  • 2
LVL 43

Accepted Solution

Eugene Z earned 1200 total points
ID: 22916852
you can check this link :

OLE DB Provider for Exchange


LVL 51

Assisted Solution

by:Mark Wills
Mark Wills earned 300 total points
ID: 22917043
Have tried that linked server before and couldn't make it happen for me...

Ended up downloading and using GeniusConnect : http://www.geniusconnect.com/articles/GeniusConnect/2/3/2/

Have also played with : http://www.aid4mail.com/overview.php

Did come across a linked server / openquery object that did work, but after I had installed GeniusConnect. Will try to find it, though was a bit past it at the time...
LVL 43

Assisted Solution

by:Eugene Z
Eugene Z earned 1200 total points
ID: 22917093
LVL 51

Expert Comment

by:Mark Wills
ID: 22917133
Can also try OA procedures with CDO objects...

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You finally migrated Public Folders to Office 365, decommissioned the Public Folder mailbox database and since then, when you send an email from on-premise to mail-enabled Public Folders, you get the following error: "Misconfigured public folder mai…
In my humble opinion (IMHO), TouchDown from Symantec is the best in class for this type of application, but Symantec has end-of-lifed it and although one can keep using it, it will no longer be supported or upgraded.  Time to look for alternatives t…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question