getting problem with NAV linked server

(0) Share

Report

Posted on by Gautam

3,945

Hi,

i am using the application NAV and have written the query in the application. am using adodb connection as a automation variable to link to the SQL Server.
The problem is that , the query which i have written executes only when i am working on local machine .
I mean when i want to execute this query from another system through NAV , it is not getting executed .

Thanks in advance

*This post is locked for comments

All responses (4)

Answers (0)

Suggested answer

Tharanga Chandrasekara 23,116 on at

Like (0)

Report

RE: getting problem with NAV linked server

Is there any error throwing or it does not return the result dataset?

Check the authentication and server path.
Suggested answer

Suresh Kulla 47,787 on at

Like (0)

Report

RE: getting problem with NAV linked server

Make sure the server is accessible from other system and try to use IP address if name of the server does not work.
mmv 11,467 on at

Like (0)

Report

RE: getting problem with NAV linked server

Hi,

If you are getting any error, please post it for better analysis.

Best Regards,

MMV
Suggested answer

Mohana Yadav 60,228 Super User 2025 Season 1 on at

Like (0)

Report

RE: getting problem with NAV linked server

Did you provide proper server and authentication details?

Do you have any error?