0 Replies Latest reply on Nov 15, 2011 11:47 AM by JamesLiang

    Link server on SQL Management Studio 2008

    JamesLiang

      Title

      Link server on SQL Management Studio 2008

      Post

      Hi Sir,

        I set a link server with FM DB on MS SQL MS, connect test is ok. but I couldn't open the table.

      system show " Cannot obtain the schema rowset "DBSCHEMA_TABLES" for ole db provider "MSDASQL"

      for linked server "FM_BONSAI".

      The Provider supports the interface, but returns a failure code where it is used (Error :7311)

      does anybody can let me know how to resolve this issue ?

       

      Thanks