8 Replies Latest reply: Sep 11, 2013 8:39 PM by user1298709 Branched to a new discussion. RSS

    32 Bit ODBC Driver for Oracle 11g 11.2.0.1.0

    989667
      Hi Team

      I have purchased Oracle 11 g (v. 11.2.0.1.0) and installed on my Server (64 Bit Windows Server 2008 R2)
      I would like to download the 32 Bit ODBC Driver for the same version.

      The ODBC drivers are available in the Administrative Tools -> ODBC. I believe they are the 64 bit ODBC drivers.The 32 bit drivers are not available in the C:/Windows/SysWOW/ODBC.exe. How can one install the 32 bit ODBC driver.

      I found ODAC 11.2 Release 2 (11.2.0.1.2) with Oracle Developer Tools for Visual Studio in the link mentioned below
      [http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html]

      Is is okay to install the setup (Note: the versions do not match, however the installation file has the the ODBC drivers for 11.2.0.1.0 version as well).
      If yes ,can some one help me install the same. I am finding it difficult to do the same as installation is a little complicated (Home Base Selection, Software Location etc)

      I would like to confirm if the same is compatible with the installed version.
      Please instruct if any additional steps or care has to be taken for the same. I am afraid if the 32 bit driver would replace the existing 64 bit drivers.

      Could you please help me with any installation document or guide for the ODBC driver.

      Thanks in advance

      Regards
      Sanjay
        • 1. Re: 32 Bit ODBC Driver for Oracle 11g 11.2.0.1.0
          Robert Geier
          Install the 32 bit ODAC into a new home. You don't need to match the software component point versions exactly (you can use ODBC 11.2.0.1.0)
          • 2. Re: 32 Bit ODBC Driver for Oracle 11g 11.2.0.1.0
            989667
            Hi

            Thanks for your reply.

            The following are the components available in the ODBC Setup
                      
            ODAC 11.2.0.1.2 with Oracle Developer Tools for Visual Studio+

                      - Includes support for Microsoft Visual Studio 2010 and .NET Framework 4
                      
                      
            Download Includes

                      Oracle Developer Tools for Visual Studio 11.2.0.1.2
                      Oracle Data Provider for .NET 4 11.2.0.1.2
                      Oracle Data Provider for .NET 2.0 11.2.0.1.2
                      Oracle Providers for ASP.NET 4 11.2.0.1.2
                      Oracle Providers for ASP.NET 2.0 11.2.0.1.2
                      Oracle Database Extensions for .NET 4 11.2.0.1.2 -- for upgrade only
                      Oracle Database Extensions for .NET 2.0 11.2.0.1.2 -- for upgrade only
                      Oracle Provider for OLE DB 11.2.0.1.0
            *          Oracle Objects for OLE 11.2.0.1.0*
            *          Oracle Services for Microsoft Transaction Server 11.2.0.1.0*
            *          Oracle ODBC Driver 11.2.0.1.0*
            *          Oracle SQL*Plus 11.2.0.1.0*
            *          Oracle Instant Client 11.2.0.1.0*

            I am not sure if this set up file has the 32 bit ODBC drivers in specific.

            I also found a set up for download in the below mentioned link.

            http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.html


            32-bit Oracle Data Access Components (ODAC) Downloads          
                      
            Download Includes

                      Oracle Data Provider for .NET 4 11.2.0.1.2
                      Oracle Data Provider for .NET 2.0 11.2.0.1.2
                      Oracle Providers for ASP.NET 4 11.2.0.1.2
                      Oracle Providers for ASP.NET 2.0 11.2.0.1.2
                      Oracle Database Extensions for .NET 4 11.2.0.1.2 -- for upgrade only
                      Oracle Database Extensions for .NET 2.0 11.2.0.1.2 -- for upgrade only
                      Oracle Provider for OLE DB 11.2.0.1.0
                      Oracle Objects for OLE 11.2.0.1.0
                      Oracle Services for Microsoft Transaction Server 11.2.0.1.0
                      Oracle ODBC Driver 11.2.0.1.0
                      Oracle SQL*Plus 11.2.0.1.0
                      Oracle Instant Client 11.2.0.1.0

            Is that the setup that has to be used to install the 32 bit drivers.

            If both are incorrect, could you please help me with the correct link.

            Regards
            Sanjay
            • 3. Re: 32 Bit ODBC Driver for Oracle 11g 11.2.0.1.0
              Robert Geier
              If you want the 32 bit ODBC drivers, then yes, you need to download and install the 32 bit ODAC.
              • 4. Re: 32 Bit ODBC Driver for Oracle 11g 11.2.0.1.0
                989667
                This should be installed onto a new directory, right ? (any directory can be made new Oracle Home Base).
                By installing the same the 32 bit ODBC drivers would be available in C:/Windows/SWSWOW64/odbc32.exe right ?

                Am doing this for one of my client (critical data) & I am a newbie in Oracle, please don mind if my questions are really silly. :)

                Regards
                Sanjay
                • 5. Re: 32 Bit ODBC Driver for Oracle 11g 11.2.0.1.0
                  Robert Geier
                  Yes, 32 bit install should be into a new home / directory.
                  • 6. Re: 32 Bit ODBC Driver for Oracle 11g 11.2.0.1.0
                    Chanchal Wankhade
                    Hi,

                    Download and install oracle client 64 bit since you are using 64 bit server.
                    • 7. Re: 32 Bit ODBC Driver for Oracle 11g 11.2.0.1.0
                      Tridus
                      Chanchal Wankhade wrote:
                      Hi,

                      Download and install oracle client 64 bit since you are using 64 bit server.
                      No, the 32 bit one is required to use a 32 bit ODBC application. It works alongside the 64 bit one, so you can have both.
                      • 8. Re: 32 Bit ODBC Driver for Oracle 11g 11.2.0.1.0
                        user1298709

                        ODBC 32bit exe

                        %windir%\SysWOW64\odbcad32.exe

                         

                        ODBC 64bit exe

                        %windir%\System32\odbcad32.exe

                         

                        Control+r

                        Paste

                        Profit

                         

                        The window will display both 32 and 64 bit versions of your connections but will create only the version you ran until you switch over to the other..