Linked server from SQL server 2008(64 bit) to Oracle 9i


  • Hello,

    I would like to link databases from SQL server 2008 R2 (64bit) to Oracle 9i (32bit).

    My goal is creating VIEWS on SQL server by using data from SQL server and Oracle.

    I have checked some Questions & Answers on Forum, but I couldn't find which a driver is appropriate.

    Please let me know:

    -  Which driver I should use / where the download site is.
    -  If any other software (like Oracle client) needs to be installed.

    **Windows Server 2008 R2
    **SQL server 2008 R2 (64bit)

    Thank you.


    Tuesday, February 26, 2013 7:05 AM


All replies