Error while executing queries using Linked server to Oracle

  • OLE DB provider 'MSDAORA' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.

  • Try using the Oracle OLE DB provider. The Microsoft OLE DB provider for Oracle is 32-bit only and is deprecated.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply