Using MS Exchange and MS SQL Server 2000

• Coolmaster

  SSC Enthusiast

  Points: 153

  More actions

  December 21, 2001 at 5:18 am

  #77642

  I'm currently looking for method to access data (email, note...) in MS Exchange Server, modify and update data. I would also to add new data in MS Exchange Server (new note). Is there any way to do it, did somebody already done something like that.

  Thank you...

  Robert Rusic

• David Benoit

  SSC-Dedicated

  Points: 34562

  More actions

  December 21, 2001 at 8:06 am

  #421356

  There is an OLE DB Provider for Exchange that is documented in BOL that is supposed to allow for connectivity and querying from SQL Server however, I have not tried it. I am assuming this is the same provider that is used with MS Access and if so, it works fine. However, this will not allow updates to the Exchange store (from what I have seen). I believe that you would have to do some programming using the MAPI interface to do what you are proposing.

  Hope this helps.

  David

  David

  @SQLTentmaker

  “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738013

  More actions

  December 21, 2001 at 10:06 am

  #421370

  Check this out:

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_0t5x.asp

  Bug:

  http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q300385

  This also might help:

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/_cdo_idatasource_saveto.asp

  Steve Jones

  steve@dkranch.net