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

  • 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.

  • 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.

  • 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.

  • 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