• But none of this helped.I dont see the oraoledb.oracle driver in the Linked servers providers list.I am able to connect the Oracle client with the Oracle DB.

    Please advice what could be the reason.

    run the c:\windows\SysWOW64\odbcad32.exe version, and confirm the oracle driver is present.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle