dbTalk Databases Forums  

Linked Server object

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss Linked Server object in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
BMW
 
Posts: n/a

Default Linked Server object - 10-18-2006 , 05:43 PM






I found the article abount linking exchange server with Sql 2005

EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders'

I didn't see the 'Exchange OLE DB provider',
'exoledb.DataSource.1',

Do you have any idea how I can link the exchange server?
Can I search Exchange inbox in sql 2005?

Reply With Quote
  #2  
Old   
Sue Hoegemeier
 
Posts: n/a

Default Re: Linked Server object - 10-18-2006 , 08:13 PM






Is Exchange on the same box as SQL Server? The Exchange
install would have installed the provider. It's a server
side only provider so they need to be on the same box.

-Sue

On Wed, 18 Oct 2006 15:43:02 -0700, BMW
<BMW (AT) discussions (DOT) microsoft.com> wrote:

Quote:
I found the article abount linking exchange server with Sql 2005

EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders'

I didn't see the 'Exchange OLE DB provider',
'exoledb.DataSource.1',

Do you have any idea how I can link the exchange server?
Can I search Exchange inbox in sql 2005?


Reply With Quote
  #3  
Old   
BMW
 
Posts: n/a

Default Re: Linked Server object - 10-19-2006 , 11:52 AM



Hi Sue,

Is it means that the SQL Server and Exchange Server must on the same computer?

If they are on the same machine, can I serach Exchange inbox through the
stroe procedure in SQL?

Thanks.

"Sue Hoegemeier" wrote:

Quote:
Is Exchange on the same box as SQL Server? The Exchange
install would have installed the provider. It's a server
side only provider so they need to be on the same box.

-Sue

On Wed, 18 Oct 2006 15:43:02 -0700, BMW
BMW (AT) discussions (DOT) microsoft.com> wrote:

I found the article abount linking exchange server with Sql 2005

EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders'

I didn't see the 'Exchange OLE DB provider',
'exoledb.DataSource.1',

Do you have any idea how I can link the exchange server?
Can I search Exchange inbox in sql 2005?



Reply With Quote
  #4  
Old   
Sue Hoegemeier
 
Posts: n/a

Default Re: Linked Server object - 10-19-2006 , 10:46 PM



Yes. Just like the topic in books online states:
The Exchange Web Store should be located in the same
computer as SQL Server. Web Stores located in other
computers cannot be accessed by using the OLE DB Provider
for Exchange.
Then you can follow the example in books online.

-Sue

On Thu, 19 Oct 2006 09:52:01 -0700, BMW
<BMW (AT) discussions (DOT) microsoft.com> wrote:

Quote:
Hi Sue,

Is it means that the SQL Server and Exchange Server must on the same computer?

If they are on the same machine, can I serach Exchange inbox through the
stroe procedure in SQL?

Thanks.

"Sue Hoegemeier" wrote:

Is Exchange on the same box as SQL Server? The Exchange
install would have installed the provider. It's a server
side only provider so they need to be on the same box.

-Sue

On Wed, 18 Oct 2006 15:43:02 -0700, BMW
BMW (AT) discussions (DOT) microsoft.com> wrote:

I found the article abount linking exchange server with Sql 2005

EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders'

I didn't see the 'Exchange OLE DB provider',
'exoledb.DataSource.1',

Do you have any idea how I can link the exchange server?
Can I search Exchange inbox in sql 2005?




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.