Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Setting up linked servers with an out-of-process OLEDB provider Expand / Collapse
Author
Message
Posted Wednesday, June 8, 2011 11:14 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 3:29 PM
Points: 5,046, Visits: 10,571
Comments posted to this topic are about the item Setting up linked servers with an out-of-process OLEDB provider

--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1122208
Posted Wednesday, June 8, 2011 11:16 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 21, 2014 5:31 PM
Points: 33, Visits: 413
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
Post #1122209
Posted Thursday, June 9, 2011 12:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 2:13 AM
Points: 3, Visits: 95

Fine, you made a great job.

Post #1122230
Posted Thursday, June 9, 2011 1:34 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 7:03 AM
Points: 81, Visits: 903
Excellent article - thank you
Post #1122253
Posted Thursday, June 9, 2011 1:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:56 AM
Points: 7,010, Visits: 8,462
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


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- 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
Post #1122257
Posted Thursday, June 9, 2011 2:44 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 8, 2014 6:15 PM
Points: 2,278, Visits: 3,793
Gian,

This article is highly informative. Great stuff.
Thanks for the time in preparing this material.
I guess you might taken weeks for this.


Mohammed Moinudheen
Post #1122280
Posted Thursday, June 9, 2011 2:55 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 3:29 PM
Points: 5,046, Visits: 10,571
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

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1122288
Posted Thursday, June 9, 2011 4:44 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:08 AM
Points: 5,992, Visits: 12,941
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.


---------------------------------------------------------------------

Post #1122358
Posted Thursday, June 9, 2011 5:58 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, September 11, 2014 5:55 AM
Points: 2,302, Visits: 560
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!



Post #1122405
Posted Thursday, June 9, 2011 6:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 3:29 PM
Points: 5,046, Visits: 10,571
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

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1122414
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse