?
Solved

Linked Server Exchange 2003

Posted on 2005-04-05
4
Medium Priority
?
350 Views
Last Modified: 2010-05-18
Have managed to return a variety of error codes, still no luck connecting.
Suspect one of these values?

SRV_DATASOURCE or
SRV_PROVIDERSTRING

Error Messages;

Could not create a new session on OLE DB provider 'exoledb.DataSource.1'.
OLE DB error trace [OLE/DB Provider 'exoledb.DataSource.1' IDBCreateSession::CreateSession returned 0x80040e19].

Error 7304: Could not create a new session on OLE DB provider
OLE DB trace error IDBCreateSession:: CreateSession Returned 0x80040e10

Other Codes;
0x80150804

0x8007007b


Thanx in Advance,

G
0
Comment
Question by:Greg Rowland
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 4

Author Comment

by:Greg Rowland
ID: 13967763
Solution

SQL Server Books online, search "OLE DB Provider for Exchange"

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

/*
Key elements in this example;
SQL 2000 must be running on the same computer as Exchange 2003.
The ‘file:’ name is actually an alias, found by exploring the IIS Exchange web, properties.

*/

-- Drop a linked server by name
EXEC sp_dropserver 'Exchange', 'droplogins'
go

-- List linked Servers -----------------------
EXEC sp_linkedservers
GO

0
 
LVL 2

Accepted Solution

by:
Lunchy earned 0 total points
ID: 13990010
Closed, 0 points refunded.
Lunchy
Friendly Neighbourhood Community Support Admin
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question