Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Exchange OLE DB provider

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-05-13 : 01:45:59
Todd writes "I'm trying to setup an linked server to an Exchange server
both the SQL 2000 sp 2 and Exchange 2000 sp2 server are on the same
server.

I believe I'm getting hang on the Data Source entry.
Looking at documentation on msdn it shows to create a
linked server with the following commands.

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

I can run this without errors. However when I click on
the Tables option under the linked server in the Console I
get an error 7304: Could not create a new session on OLE
DB Provider "exoledb.DataSource.1"

I have not be able to find a share name
backofficestorage. I have tried a couple of different
combinations for the Data Source field. Includeing removing the
backofficestorage. Changeing localhost to myserver or
myserver.mydomain.com

Any help would be greatly appreciated. Thanks in advance
for your time.

Todd"
   

- Advertisement -