SQL Server Performance


Discussion in 'General DBA Questions' started by ghemant, Aug 25, 2011.

  1. ghemant Moderator


    For one of our client we are facing issue with Oracle link server (using MSDAORA), the issues is :

    1) I have noticed that if we use SQL Authentication simple select statement works i.e.
    select top 10 * from linkserver..schema.table produced output and the same statement gives an error


    2) I have noticed that MSDAORA doesn't exists in component does that mean, it is not installed / configured properly?

    I have referred to article :

    a) http://blogs.msdn.com/b/dataaccesst...nked-server-with-out-of-process-provider.aspx


    b) http://blogs.msdn.com/b/asiatech/ar...sue-with-linked-oracle-server-on-win2003.aspx
    Windows Server 2003 Enterprise R2, SP2
    SQL Server 2000 Enterprise, 8.0.2040
    -- client is testing the application with compatible code on SQL Server 2008 R2
  2. ghemant Moderator


    The issue has been resolved, it was an issue with MSDAORA.DLL, re-registering this dll save us.


Share This Page