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://<<ExchangeServerName>>"')
go
0 comments
Hide comments