How can I access Exchange stores from SQL Server?
Neil Pike
November 1, 1999
1 Min Read
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
About the Author
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