How can I access Exchange stores from SQL Server?

Neil Pike

November 1, 1999

1 Min Read
ITPro Today logo in a gray background | ITPro Today

A. 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://<>"')
go

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like