Setting up linked servers with an out-of-process OLEDB provider

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Gianluca Sartori » Setting up linked servers with an...

16 posts, Page 2 of 2

««1 2

Setting up linked servers with an out-of-process OLEDB provider

Rate Topic

Display Mode

Topic Options

Author

Message

Eric M Russell

Posted Thursday, June 09, 2011 7:20 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:02 PM
Points: 1,162, Visits: 3,333

One of the best articles on the web for configuring linked server connections. The part that describes what specific resources a provider must be granted access to before it will run out-of-process is especially useful, and I'm sure there is a long story with plenty or trial and error. Thanks.

"Wise people understand the 10,000 things without going to each one.
They know them without having to look at each one,
and they transform all without acting on each one." - The Tao Te Ching: Verse 47

Post #1122484

spaghettidba

Posted Thursday, June 09, 2011 7:26 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:29 AM
Points: 4,804, Visits: 8,067

Eric M Russell (6/9/2011)

... I'm sure there is a long story with plenty or trial and error.

...longer than you could ever imagine!
Thank you.

Get your two-cent-answer quickly
The Spaghetti DBA

Post #1122492

@SixStringSQL

Posted Thursday, June 09, 2011 9:29 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:22 PM
Points: 65, Visits: 254

Excellent, excellent article, Gianluca!

-Grubb

Post #1122660

SQLRNNR

Posted Thursday, June 09, 2011 9:38 AM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 18,733, Visits: 12,332

Nice article Gianluca.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1122669

Jon Russell

Posted Monday, June 13, 2011 10:10 AM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 1:22 PM
Points: 326, Visits: 894

Good thorough article, Gianluca.

Post #1124410

Koen Verbeeck

Posted Friday, July 29, 2011 3:42 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 7:39 AM
Points: 9,370, Visits: 6,467

Great article! It helped me solve my linked server problem. (as for some reason the Microsoft OLE DB provider for DB2 didn't want to run InProcess. The bastard BigGrin

)
But so overly complex, Microsoft could spend some time to simplify this...

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1150756

« Prev Topic | Next Topic »

16 posts, Page 2 of 2

««1 2

Permissions