I have problems with my sql script using linked server (not even sure if the syntax is correct). Anyway, get error:
The OLE DB provider "AS400SRV_MSDASQL" has not been registered.
insert into #JDE_EqmTable
SELECT *
FROM OPENROWSET('AS400SRV_MSDASQL','Data Source=vgsys400;Trusted_Connection=yes;
Integrated Security=SSPI','EXEC QGPL.get_labdet @JobNumber1, @ItemNumber1, @JdeDateFrom, @JdeDateTo')
The OLE DB provider "AS400SRV_MSDASQL" has not been registered.
insert into #JDE_EqmTable
SELECT *
FROM OPENROWSET('AS400SRV_MSDASQL','Data Source=vgsys400;Trusted_Connection=yes;
Integrated Security=SSPI','EXEC QGPL.get_labdet @JobNumber1, @ItemNumber1, @JdeDateFrom, @JdeDateTo')
