#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2013
    Posts
    5
    Rep Power
    0

    Linked Server SQL to Oracle.


    I am trying to select data from an Oracle Server from a SQL Server and I am getting 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;

    How do I go about fixing it?
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2013
    Location
    Pennsylvania, USA
    Posts
    35
    Rep Power
    2
    Looks like a server side problem. Try contacting the people who set up the Oracle server and ask them to enable the remote database operations you need.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2013
    Posts
    5
    Rep Power
    0

    Nothing to setup.


    According to them there is nothing additional they need to do on the Oracle end. It should work.

IMN logo majestic logo threadwatch logo seochat tools logo