AnsweredAssumed Answered

Link server on SQL Management Studio 2008

Question asked by JamesLiang on Nov 15, 2011

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

Outcomes