Linked server

weneedweneed Member Posts: 51
I'm using linked server to use external table in Nav but when try to open table return an error:

"The microsoft DTC ha cancelled the distributed transactions".
How I can solve?

Answers

  • weneedweneed Member Posts: 51
    I try to give some more information:
    Dynamics NAV 2015 version. There are some tables with LinkedObject property is set to true. Necessary views have been created in SQL. These views using linked server.
    EVERYTHING WORKS PROPERLY.

    New version of NAV (BC14 - RTC). The database has been converted. The same views are therefore present. Running the tables returns the following error:
    e5ac4uiv8efy.png

    If try to run SQL views from SQL Management Studio all work great and no problems.
  • Developer101Developer101 Member Posts: 452
    The issue is more clear now when you mentioned the application versions. The linkedobject property on tables was a navision thing and deprecated in Business Central
    United Kingdom
  • weneedweneed Member Posts: 51
    maybe but that's not the problem.
    I am still using the (BC14) RTC version and the property is still available.
  • Developer101Developer101 Member Posts: 452
    Ok fine. Is your solution is based on extensions or c/al?
    United Kingdom
  • weneedweneed Member Posts: 51
    C/AL
Sign In or Register to comment.