Linked server

weneed
weneed Member Posts: 82
in NAV Three Tier
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

  • weneed
    weneed Member Posts: 82
    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.
  • Developer101
    Developer101 Member Posts: 569
    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
  • weneed
    weneed Member Posts: 82
    maybe but that's not the problem.
    I am still using the (BC14) RTC version and the property is still available.
  • Developer101
    Developer101 Member Posts: 569
    Ok fine. Is your solution is based on extensions or c/al?
    United Kingdom
  • weneed
    weneed Member Posts: 82
    C/AL

Categories