New information: In earlier tests I was logging in to SQL Server using Windows authentication. All queries with the linked server using IBM/Rocket's UniOLEDB driver failed. Over the weekend the client set up my user ID using SQL Server authentication, and the queries now work (on the old server; the new server is still a mess). The authentication method is the only thing that changed. This then begs the question: What Windows permissions are being respected by the UniOLEDB driver that it would work in one authentication scheme but not the other?
-Kevin http://www.PrecisOnline.com _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users