August 10, 2004 at 1:38 pm
My firm has a SQL server database in which we store contact information of clients. We would like to synchronize the company contacts in a public outlook folder (exchange server 2000) with the contacts table / view in the database. Does anyone know how this can be done and/or any good resources on the subject?
August 11, 2004 at 6:02 am
Yes, this can be done.
You need to have the OLEDB provider for Exchange and create a remote server connection to Exchange from SQL Server.
start here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/wss_references_wss.asp
October 5, 2004 at 9:24 pm
unfortunately, I did not find the msdn site very helpful. I am relatively new to SQL server, and some of the content seemed foreign to me (CoTypes, MAPI content classes, etc) What is the OLEDB provider for exchange? (how do I access it?). Essentially, my goal would be to a have a SQL Server table updated daily with the data from our company contact list (in a public outlook folder on the exchange server). I assume I can do this with a DTS package, or via an ADO connection / recordset using VBA in my .adp front end. For example, using an ADO connection, how would I know how to define the connection string, and how would I know the "table"/"column" names for the contacts folder of interest.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply