bw03 (7/27/2011)
32bit. We're using the OLEDB provider not ODBC.
You had mentione that the developer is sysadmin on sql server so i find it strange that something is stopping him.I suggest you run the profiler and ask your developer to try and fire a query using the linked server and see if something comes up in profiler.
Also, i would like you to open a question in msdn forums in an rea which deals with connections from SQL to heterogenous database engines.