• 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.