Just out of curiosity, does the database actually contain the table InventTable?
Not played with AX in over 18 months so cant remember if its a standard table or not.
Also what is the collation of the AX database? If its case sensitive then you will need to ensure you query it case sensitive as your using the remote collation.
So InventTable <> INVENTTABLE.
Typically AX tables are all upper case.
INVENTTABLE yes is a standard table of AX.
The collation of my AX Dbase is SQL_Latin1_General_CP1_CI_AS
I tried running the script again using uppercase letters but its still the same.
I noticed something though, when I opened my Linked Servers in the server objects. I have not found the AX Databse in my catalogs.. see image below.
This is my SRV-AXDEV list of databases:
I tried doing it the other way around, that is, I created a linked server SRV-APP1 in my SRV-AXDEV server, and it worked. I also tried using the IP Address of AXDEV as a linked server instead of its logical name and it also worked.. It's odd, I don't know what's wrong..
The more you learn, the more you realize how little you know…