SQL Server Performance

MSDAORA Errors

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

  1. ghemant Moderator

    Hi,

    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
    
    Configuration:
    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
    
    
    ghemant, Aug 25, 2011
    #1

  2. ghemant Moderator

    Guys,

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

    Regards
    ghemant, Aug 25, 2011
    #2

Share This Page