| Home |
| Articles |
| Backup |
| Books |
| Certification |
| FAQ |
| Products |
| Replication |
| Scripts |
| Seminars |
| Training |
| TSQL |
|
| MSDN Fourms |
| Philippine SSUG |
| Fort Worth SSUG |
| Oklahoma City SSDG |
|
| Resume |
|
| MHS Enterprises |
| BlowFrog Software |
| FilAm Software |
| AcrylicAcetate.com |
| Bargain Humidors |
| Western Humidor |
|
|
How can I access Exchange
stores from SQL Server?
Several methods :-
- Purchase an ODBC/OLE-DB driver from Intersolv.
- 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).
- 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.
- 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
|
