locked
Allow In Process RRS feed

  • Question

  • Hi,

    Under linked servers providers: which of the following providers should be setup for "allow in process"

    1. ADsDSOObject
    2. DTSPackageDSO
    3. Microsoft.Jet.OLEDB.4.0
    4. MSDAORA
    5. MSDAOSP
    6. MSDMine
    7. MSIDXS
    8. MSOLAP
    9. MSOLAP
    10 SQLNCLI
    11 SQLOLEDB
    12 SQLReplication.OLEDB

     

    Thursday, November 22, 2012 10:40 PM

Answers

  • Not all the providers are designed to run outside process. First test if the provider can loadoutside the process and then decide.

    I would recommend any Non microsoft providers to run outside process (But the provider should support running outside).


    Thank you,

    Karthick P.K |My Site|My Scribbles |Blog Space |Twitter|My Facebook Group|

    www.Mssqlwiki.com

    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    • Proposed as answer by Shulei Chen Monday, November 26, 2012 3:05 AM
    • Marked as answer by Shulei Chen Friday, November 30, 2012 2:10 AM
    Friday, November 23, 2012 3:29 AM