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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

Did you provide proper server and authentication details?

Do you have any error?

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

Hi,

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

Best Regards,

MMV

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Make sure the server is accessible from other system and try to use IP address if name of the server does not work.

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

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

Check the authentication and server path.

Was this reply helpful? Yes No