Can't Query Exchange Linked To SQL Server

Can't Query Exchange Linked To SQL Server

Post by atomik eg » Thu, 31 May 2001 15:42:36



I linked an Exchange folder to SQL Server 7.0 according to instruction in
msdn, but no query statement, including the statement given by MSDN, can
successfully return records from the linked table. How can one select from
an Exchange linked server in SQL 7.0?

What do you make of this contradiction?
  "The Exchange Web Store should be located in the same computer as SQL
Server. Web Stores located in other computers cannot be accessed using the
OLE DB Provider for Exchange." -MSDN article

  "WARNING: DO NOT INSTALL SQL SERVER 2000 on the SAME server as Exchange
2000.  This installs MDAC 2.6 which is not supported with Exchange 2000 yet.
MDAC 2.6 will be supported with SP1 of Exchange 2000." -MSDN sample Exchange
Training application ReadMe.txt.

 
 
 

Can't Query Exchange Linked To SQL Server

Post by atomik eg » Thu, 31 May 2001 15:43:04


I linked an Exchange folder to SQL Server 7.0 according to instruction in
msdn, but no query statement, including the statement given by MSDN, can
successfully return records from the linked table. How can one select from
an Exchange linked server in SQL 7.0?

What do you make of this contradiction?
  "The Exchange Web Store should be located in the same computer as SQL
Server. Web Stores located in other computers cannot be accessed using the
OLE DB Provider for Exchange." -MSDN article

  "WARNING: DO NOT INSTALL SQL SERVER 2000 on the SAME server as Exchange
2000.  This installs MDAC 2.6 which is not supported with Exchange 2000 yet.
MDAC 2.6 will be supported with SP1 of Exchange 2000." -MSDN sample Exchange
Training application ReadMe.txt.

 
 
 

1. Can't Query Exchange Linked to SQL Server

I linked an Exchange folder to SQL Server 7.0 according to instruction in
msdn, but no query statement, including the statement given by MSDN, can
successfully return records from the linked table. How can one select from
an Exchange linked server in SQL 7.0?

By the way, what do you make of this contradiction?
  "The Exchange Web Store should be located in the same computer as SQL
Server. Web Stores located in other computers cannot be accessed using the
OLE DB Provider for Exchange." -MSDN article

  "WARNING: DO NOT INSTALL SQL SERVER 2000 on the SAME server as Exchange
2000.  This installs MDAC 2.6 which is not supported with Exchange 2000 yet.
MDAC 2.6 will be supported with SP1 of Exchange 2000." -MSDN sample Exchange
Training application ReadMe.txt.

ae

2. database recover

3. Server Side Rule Error

4. Can't Query Exchange Linked To SQL Server

5. Messages with an unreachable destination

6. Can't Query Exchange Linked to SQL Server

7. CDO, CDONTS, Exchange ???

8. Can't Query Exchange Linked To SQL Server

9. how can I build 2 queries in 1 query(VB SQL query)

10. Exchange 5.5 as SQL Server 7 Linked Server

11. Linking Exchange Server with SQL Server

12. Exchange 5.5 Contact list linked wih SQL Server