"You cannot create an Automation object "ADO Connection" on Microsoft Dynamics NAV Server.

Business Central/NAV Developers Forum
1

What is the reason behind this error: “You cannot create an Automation object “ADO Connection” on Microsoft Dynamics NAV Server. You must create it on a client computer.”

2

Welcome to DUG

You have to add new parameter in CREATE statement of automation variable.

Search the forum please.

3

use create(,false,true) instead of create()

otherwise nav tries to run the automation on the server which is not allowed for nav vs. >= 2013

you need a installed version of the automation on each client computer.

http://msdn.microsoft.com/en-us/library/dd355255(v=nav.70).aspx

p.s.: please always tag your postings with at least the nav version (nav 2009, nav 2013,…)

4

The solution is change the code like shown below:

CREATE(ADOConnection,FALSE,TRUE);