This discussion is archived
4 Replies Latest reply: Sep 17, 2013 9:58 PM by kgronau RSS

Need to connect 8i to SQL server 2012

997407 Newbie
Currently Being Moderated

How can I connect 8i to sql server 2012. I can do this with sql server 2008 but not with 2012

is there a specific oracle client or ODAC that I need/

 

Any help appreciated.

  • 1. Re: Need to connect 8i to SQL server 2012
    sb92075 Guru
    Currently Being Moderated

    You can't avoid upgrading indefinitely!

    8i has been obsoleted this whole Century.

    I bet you just can't get there  from here.

  • 2. Re: Need to connect 8i to SQL server 2012
    997407 Newbie
    Currently Being Moderated

    Hmm maybe not. But we won't be upgrading as our main system is changing and will be SQL back end. Just need to migrate legacy data.

  • 3. Re: Need to connect 8i to SQL server 2012
    sb92075 Guru
    Currently Being Moderated

    In the Oracle world SQL*Client inter-operate within 2 major releases.

    V7 can work with V9; but not V10

    V8 can work with V10; but not V11

    Similar is true when discussing underlying OS version.

    No upwards compatibility is ever guaranteed.

  • 4. Re: Need to connect 8i to SQL server 2012
    kgronau Guru
    Currently Being Moderated

    8i is desupported, that's true, but when running this old release I think you do not really take care about supported releases. Unfortunately you didn't state on which platform your 8i is running. Maybe you could use HSODBC in 8i which was shipped on some platforms like Windows, Solaris, HP-UX and AIX. So that might be an option for you. The other alternative would be to change the driving site and let SQL Server fetch the data. Just in that case you only need to install a compatible Oracle client on the SQL Server box (compatible means certified for the OS where the SQL Server is running and also a client that can connect to the old 8i database) which contains the ODBC driver and/or the OLEDB driver and then connect to the Oracle database from the SQL Server using SQL Server Linked Server mechanism.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points