Setting up linked servers with an out-of-process OLEDB provider
-
Comments posted to this topic are about the item Setting up linked servers with an out-of-process OLEDB provider
-- Gianluca Sartori
-
Hah. I never knew what the in-process checkbox was for, on the provider properties, only that I had to check it, in order for the linked server to actually work. lols
Now I know a little more, and I'll keep checking it every time I need one. hahaha!
Thanks,
sff
-
Fine, you made a great job.
-
Excellent article - thank you
-
It was my pleasure to get a first glimps of your article.
This is a lesser known topic, but definately has its place in SQL instance management topics.
Great job !
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Gian,
This article is highly informative. Great stuff.
Thanks for the time in preparing this material.
I guess you might taken weeks for this.
M&M
-
ALZDBA (6/9/2011)
It was my pleasure to get a first glimps of your article.This is a lesser known topic, but definately has its place in SQL instance management topics.
Great job !
Johan, I really appreciated your feedback and you certainly made this article better.
Thank you.
-- Gianluca Sartori
-
nice article gianluca, its good to have this sort of information out there in one article.
I gotta ask though, should it really be that convoluted! MS all over.
---------------------------------------------------------------------
-
Nice article.
It makes me wonder why 64-bit SQL can't use 32-bit providers (eg Jet), since the bit-ness of out-of-process COM components doesn't matter. They'd only need a 32-bit host process.
It might be more complicated to set up, but surely it would be easier that the current workaround of putting a 32-bit SQL Express instance in the middle!
-
richardd (6/9/2011)
Nice article.It makes me wonder why 64-bit SQL can't use 32-bit providers (eg Jet), since the bit-ness of out-of-process COM components doesn't matter. They'd only need a 32-bit host process.
It might be more complicated to set up, but surely it would be easier that the current workaround of putting a 32-bit SQL Express instance in the middle!
That's an interesting question!
You can define a custom surrogate process for a COM component in the registry. I don't know if it can be set to use a 32 bit surrogate, but this thread suggests it can be done. It would be great if you could try and give us some feedback.
-- Gianluca Sartori
-
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.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
-
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.
-- Gianluca Sartori
-
Excellent, excellent article, Gianluca!
-Grubb
-
Nice article Gianluca.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
Good thorough article, Gianluca.
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply