June 8, 2011 at 11:14 pm
Comments posted to this topic are about the item Setting up linked servers with an out-of-process OLEDB provider
-- Gianluca Sartori
June 8, 2011 at 11:16 pm
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
June 9, 2011 at 12:55 am
Fine, you made a great job.
June 9, 2011 at 1:34 am
Excellent article - thank you
June 9, 2011 at 1:41 am
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
June 9, 2011 at 2:44 am
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
June 9, 2011 at 2:55 am
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
June 9, 2011 at 4:45 am
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. 🙂
---------------------------------------------------------------------
June 9, 2011 at 5:58 am
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!
June 9, 2011 at 6:19 am
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
June 9, 2011 at 7:20 am
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
June 9, 2011 at 7:26 am
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
June 9, 2011 at 9:29 am
Excellent, excellent article, Gianluca!
-Grubb
June 9, 2011 at 9:38 am
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
June 13, 2011 at 10:10 am
Good thorough article, Gianluca.
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply