I am executing a DS job which fails at the procedure node with the error:
[DBNETLIB] Server does not exists or access denied.
[DBNETLIB] ConnectionOpen Connect(()).
Actually the Procedure node is executing a stored procedure which is on the other server (database server) and the stored procedure is working fine in the database server.Following is the logic in the procedure node:
IF(NOT EXEC_SP('procedure_name'))
THEN EXIT(-1);
Also EXEC_SP is a function which is defined and holds expressions for two variable database (lookup from the target connection),server(lookup from the target connection) and a $cmd variable which I think establishes connection to the server (Database server) and the database.
But when I test this function it displays the output value but it also shows the same cmd error
[DBNETLIB] Server does not exists or access denied.
[DBNETLIB] ConnectionOpen Connect(()).
Please help me with this issue as I got stuck at this point and cannot perform the job successfully.Any help would be greatly appreciated.Thanks.
Hi,
I don't think you can use a procedure node to call a stored procedure in a database directly You would perhaps use a SQL() function or a SQL Node? When you refer to EXEC_SP as being a function, do you mean it's an external UDF, compiled into a dll? If so, my money is on the coding of this being flawed somewhere.
MF.