Hi,

What error are you getting? the OLE DB datasource will work if you choose 'SQL command' as the Data access mode and in the SQL command text use

exec spName...

Thanks - now I understand what would have been happening.

I have finally resolved the problem.  Rebooting the server fixed the issue.  I still get the error however from my xp...

Thanks,

The linked server already had it enabled.  I've got a scheduled reboot on Sunday, that will hopefully apply the security settings ive changed.

Thanks for your help.  I ended up only having to restart the DTC service and this SPID was killed.

It seems to be a DTC issue on the new linked server. ...