SQL Server Performance

Linked server creation fails using MSDORA provider

Discussion in 'General Developer Questions' started by techbabu303, Apr 3, 2008.

  1. techbabu303 New Member

    Hi All ,
    A collegue of mine was trying to set up linked server to oracle and seems he is getting messed up as described below....
    Env :
    1>10g R2 Oracle server with the MDAC component version
    2> 10g R2 Oracle server with MDAC compnenet version or
    Issue :The issue what he see's is MDAC component gives me an error stating that the MSDORA component is not registered. Currenlty he has not given the version of MSSQL he is on but if you happen to see it any version please post.
  2. techbabu303 New Member

    The version is 2005 x64 sp 2.
  3. SQL2000DBA New Member

    Please install Oracle client on SQL Server 2005 box and try to add Linked server

Share This Page