Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009
    Posts
    8

    Unanswered: Linked server to oracle.

    Does anyone know what this error message means? How do I fix this error?
    Msg 7308, Level 16, State 1, Procedure UFN_SRBRECR_LIST, Line 7
    OLE DB provider 'MSDAORA' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.

    I am trying to run some SQL in SQL Server 2008 that will retrieve data from an Oracle database running on Lynix .

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Try a different provider for the linked server. MSDAORA is rather old. Try the .NET Connection, if you can.

  3. #3
    Join Date
    Jul 2009
    Posts
    8

    From SQL?

    Can you use the .NET connection from within SQL Server database?

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Never tried. You would need to install it first, of course. If you don't have the .NET bits, you could try to rely on OraOLEDB.Oracle.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •