This is actually documented in the RS knowledge base. I just ran across it
the other day. It says to check the option - no idea why. It also says to
check the Server Options and set Rpc Out value to True. This option will
enable the linked server to call a stored procedure.

Glad you got everything figured out.

Colin

-----Original Message-----
From: Kevin King

Final update, hopefully..  As of this moment, IT'S WORKING!

The silver bullet in this situation was some option in SQL Server called
"Allow inprocess".  Not sure what this does exactly, but this option (in
Server Objects | Linked Servers | Providers | IBM.UniOLEDB) has to be
checked for SQL Server to play nicely with the UniOLEDB driver on this one
system.  No idea why this system needs to be configured differently from any
others... any ideas?

My deepest gratitude for all of the insight, information, and opinion
helping me through this issue.  If any of you ever get nearby, margaritas on
me!

-K

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to