3 Replies Latest reply: Aug 1, 2013 2:52 AM by Kgronau-Oracle RSS

    Db Link between Oracle 9.2.0.6 and Sql Server 2008

    Barkhaa

      Hi All,

       

      Is a database link possible between the Oracle 9.2.0.6 and Sql Server 2008 ?

       

      Regards

      Barkha

        • 1. Re: Db Link between Oracle 9.2.0.6 and Sql Server 2008
          Kgronau-Oracle

          Which platform and word size is your 9.2.0.8 database running on?

          - Klaus

          • 2. Re: Db Link between Oracle 9.2.0.6 and Sql Server 2008
            Barkhaa

            Hi Klaus

             

            Its a Oracle 9.2.0.6 version database, one is running on Windows server 2003 R2 service pack 2, word size 32-bit

            The other is on Linux 2.6.9-103 , word size 32 bit and 64-bit.

             

            Regards

            Vinita

            • 3. Re: Db Link between Oracle 9.2.0.6 and Sql Server 2008
              Kgronau-Oracle

              There's only one desupported solution for 9.2.0.6 running on Windows 32bit. For 32/64bit Linux you need at least 9.2.0.8 plus a gateway compatibility patch. In this case you could then use DG4ODBC (=Database Gateway for ODBC) release 11.1.0.7.

               

              The solution for 9.2.0.6 on Windows was desupported in March 2008 so it is for sure also not a preferable solution but will work. It is called HSODBC (Heterogeneous Services based on ODBC) or HSOLEDB (Heterogeneous Services based on OLDEB). It was installed automatically when you install the Oracle database so you just have to configure it.

              I don't really like this kind of solution as it is desupported for a long time now. Better try to update the database to a newer release or at least try to apply the 9.2.0.8 database patch set and apply a gateway compatibility patch so you will be able to use the follow up product Database Gateway for ODBC release 11.1.0.7.

               

              - Klaus