I made an automated job which manipulates data in another SQL database. It worked fine in NAV 2009 but now I can't get it to start using the new task scheduler in NAV 2017. It works fine if I run it manually but when running it in a job queue entry using the task scheduler all I get is Cannot create ADO Connection Automation variable.
Is there any way to get this working without having to rewrite everything using dot net objects?
IF ISCLEAR(ADOConnection) THEN BEGIN
IF NOT CREATE(ADOConnection, false, TRUE) THEN BEGIN
ERROR('Cannot create ADO Connection automation variable.');
END;
END;
IF ISCLEAR(ADORecSet) THEN BEGIN
IF NOT CREATE(ADORecSet, false, TRUE) THEN BEGIN
ERROR('Cannot create ADO Recordset automation variable.');
END;
END;
IF ISCLEAR(ADOStream) THEN BEGIN
IF NOT CREATE(ADOStream, false, TRUE) THEN BEGIN
ERROR('Cannot create ADO Stream automation variable.');
END;
END;
ADOConnection.ConnectionString('Provider=SQLOLEDB;Data Source=ZZZZ;'
+ 'Initial Catalog=' + "Database Name" + ';User ID=YYYY;Password=XXXX;');
ADOConnection.Open;
RecordsAffected := '';
RSOption := 0;
SQLString := <somesqlstring>
WriteQuery(SQLString);
ADORecSet := ADOConnection.Execute(SQLString);
ADOConnection.Close;
*This post is locked for comments
I have the same question (0)
