Err Oops!

I hadn't set the linked servers permissions.

I can now use

rs.open "exec spxxx",cn

but I get 0 records returned