Search
  Home
  Articles
  Backup
  Books
  Certification
  FAQ
  Products
  Replication
  Scripts
  Seminars
  Training
  TSQL
MSDN Fourms
Philippine SSUG
  Resume
MHS Enterprises
FilAm Software
AcrylicAcetate.com
Bargain Humidors
Western Humidor



How can I access Exchange stores from SQL Server?

Several methods :-
  1. Purchase an ODBC/OLE-DB driver from Intersolv.
  2. Set-up a connection to the *.?DB files from Access 2000. Then make this Access 2000 database a linked-server from SQL Server. (Access 2000's JET drivers are capable of reading the Exchange files).
  3. Wait for Platinum/Exchange 6/Exchange 2000 (or whatever it's called today) to be released. This will ship with an OLE-DB driver that can be used directly from SQL Server.
  4. Use ADSI as a linked server. You must have ADSI 2.5 installed.

    sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 'ADSDSOObject', 'adsdatasource'
    go
    select * from openquery(adsi, 'select * from ''LDAP://<<ExchangeServerName>>"')
    go

Michael R. Hotek

All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.